The preferred solution, as noted by chappu, is to use an Access .adp (Project), NOT a .mdb with ODBC-linked tables.  Projects (.adp) use OLE DB for faster performance than ODBC.

Second,...

Well, you can always fire up Task Manager on his machine to see if there are any memory hogs running.  Also, even a small database can have a large memory...

Boy, this website is sloooow today!

In my hands, with large Access ADE or ADP projects, you get "Out Of Memeory" messages if your page file is too small.  Sometimes, WIndows...

I am not an expert in this, but maybe these thoughts will help...

Access projects sometimes have issues with "set nocount,"  which controls whether rowcounts are sent to access from the the FIRST...

Hi joegrass,

As a physician, and a SQL Server programmer, I have a somewhat different view of things.

First of all, you need to be very concerned about the FDA's 21CFR part...