Access 2007 Computers Lock Up on Split Database

[chaddiesel]

We use an Access database to issue purchase orders. I split the tables into a separate database that is on a shared network drive as well as individual databases for each user which contains the Forms and Queries (also on the network). We have had no problems with multiple users being in the database at the same time with Access 2000 and 2003. We have just added a couple of new Vista machines with Access 2007, and whenever these users try to enter data into the database, it locks up their Access. They continue to be locked up until the other users close out of the database. They can load their forms with no problem, but when they do anything that opens the shared Access database with all the data tables, they are locked up and out of business. Any help would be appreciated. Thanks -Chad

 

[chaddiesel]

Each user has their own database with forms and queries that is also on the server (not the local machine) that is linked to a shared database containing the tables.

-Chad