Access is taking too long to load for only one user

[Heeeeelp]

Good morning,

I have created an access database which is being used at our office by a team of eight users for almost a year now. One of the users has been having ongoing problems with the application opening up very slowly and then once he is in the database, certain forms take a long time to load. Our IT departement has recreated his profile, microsoft office has been reinstalled, his harddrive was reformated and windows xp reinstalled but nothing has made a difference. His pc is one of the newest ones in the office, and he is the only one experiencing this problem. Occassionally there are other users needing access to the database and there is never any problem. IT has tried opening the database remotely and there are no issues. We have tried opening northwind on his pc and it does open up clickly. The size of the database is under 13MB. He has more RAM than some of the other computers running the program. I'm at a loss as to how to help him here. I would greatly appreciate any suggestions.

Thank you,
Tess

 

[jadams0173]

Make sure the DB is compacted. Are all users running the same version of Access?

Also in Access 2000 if you go Tools->Options->General tab you can uncheck Track name AutoCorrect info and Perform name AutoCorrect for your production version. This will allow the db to open quicker.

You will want them checked for developement though. For more on this topic see thread702-206410

HTH

I tried to have patience but it took to long! -DW

 

[Ed2020]

I don't think this is a problem with the database. If it was it would be affecting all users.

What happens if he opens the database from one of the other user's PCs? If it opens with no problems this narrows down the problem to the PC, not the account.

If it is the PC have any tests been done on network connection performance? Try pinging the server that the database resides on from his PC and then compare results with other user's PCs. It may be worth varying the packet size during your tests. Traceroute tests may shed some light on the matter too, if it is a networking issue.

Ed Metcalfe.

Please do not feed the trolls.....