Once again, the claim that all joins force Access to retrieve all records and work locally is simply NOT true.

It IS true that some complex SQL can force that to...

• This reply was modified 5 years ago by  George Hepworth. Reason: Clarifying, extending

Actually, that's not quite how Access works with linked tables, unless, of course, you don't know what you're doing.

This query, run against an ODBC linked SQL Server table in Access,...

• This reply was modified 5 years ago by  George Hepworth.

Talk to Phillip Steifel, who created and sells Ivercy.

He's done a number of YouTube presentations that you might want to browse, as well.

George

I think at least part of the problem with understanding the role of "Access as a database" in most organizations is that it "Access", in fact, is not a database....

See my previous reply.

I upgraded here just now. It was already upgraded on the customer's site for both dev and production, so this is mostly for my convenience...

Okay, thanks. I am both lazy and a firm believer in miracles. That often combination often leads to disappointment, I'm afraid.

I forgot to mention that I'm lazy.

Rumors of the demise of Mark "Access" Twain have been rampant since shortly after the release of Access 2.0 in 1994. Such rumors have never been more true than they...

Pat has done an outstanding job of outlining the situation and there's really not much to add except, "Me too".

To answer one question about sites for Access answers, as...

Thank you. That's what I needed.

Thanks, Ed. I appreciate the additional thoughts.

Yes, I know that SQL Express and SQL Developer edition are different. No, SQL Express is not time limited. The version I keep on my own Development machine has been...

I should add that I haven't yet had time to investigate whether this is related to ODBC driver differences.

Thanks for all the good advice.

I was able, finally, to get the client's IT to install SS 2008 R2 Express, but then I had to argue for two days to...

The problem turns out to be finding the developer version for 2008 R2. Gee MS likes to be obscure.