Function running slow for different user

[speja01#]

Hello Everyone,

I have a very odd situation that I can't figure out for the life of me. I have a MSAccess 2007 database with a particular function in a module which runs in under 25 seconds for one user but over 20 minutes for another user. Both users have identical hardware and OS. The function basically iterates through a local table (approx. 12,000 records) and writes information to another local table. The fact that the operation being performed is being done locally leads me to believe something on his machine is causing it. I was hoping someone on here might have come across a similar issue and can share some troubleshooting tips. Any help would be appreciated.

[June7]

No idea. Replace the local copy of database? Maybe reinstall Access?

[speja01#]

Unfortunately I already tried both of those suggestions.

[June7]

Does the issue replicate in a new db created on that machine?

Next step may be to reinstall OS.

[Dal Jeanis]

First, make sure the slow user has the current version of the front end.

Second, make sure the slow user has the exact same LAN permissions on all relevant file folders as the fast user.

Third, check all the relevant add-ins and references used by the routine, and make sure that the proper MS VBA, Access, DOA and OLE references are selected in the same order.

Fourth, make sure that the routine is properly dimensioning the object type and is efficiently using variable objects to address the file objects. If you have questions about that statement, post the VBA here and we'll kibbitz.

If I had to bet on a single culprit, I'd guess there's a missing reference that one user's machine is resolving correctly and the other is wandering around looking for.

(Note - this post was written before the prior two were posted).