Access XP Hangs on Exit of Objects and Database
Posted on 2004-09-01
I'm not sure if this is the correct subject area to post in, but I figured I would start here.
I have numerous Access XP databases that are stored on a server in a shared folder. Most of the databases contain tables that are linked to other Access tables or SQL tables. As of late last week, all of my databases are hanging when you open certain objects (usually forms or reports) and when you exit the database. Eventually, the request will be processed and Access will do what you asked, but you have to wait anywhere from 30 seconds to 2 mintues.
I have tried all of the following to resolve the problem:
(1) Installed Office XP Service Pack 3
(2) Checked the client and the server for viruses and spyware
(3) Moved the databases to a different physical server
(4) Compacted and repaired Access databases
(5) Reindexed the SQL tables
If I move a database that has no links to my local machine, the issue goes away. If I move a database that contains links to other databases to my local machine, I have the same problem. I am starting to wonder if the problem is network related, but everything else is fine (Internet browsing, accessing other types of office documents, etc.)
At this point, I am looking for any suggestions that anyone may have...