agriff98


I have an ACCESS application that is running locally on a user's machine. When they log in, they get the error "You do not have exclusive access to the database", then they have to click "OK" 21 times before the application will open up for them. The .mdw file is named different from the .mdb file, so they aren't locking each other out.

Any ideas




Re: ACCESS - You do not have exclusive access to the database

Adamus Turner


Are the tables linked

Adamus







Re: ACCESS - You do not have exclusive access to the database

agriff98

Yes, the tables are linked.

Adam






Re: ACCESS - You do not have exclusive access to the database

Adamus Turner

If you have databound controls locking the remote tables, (I'm guessing 21 linked tables), Access is reflecting the locks.

To resolve this, Import the tables periodically instead of linking them.

Adamus






Re: ACCESS - You do not have exclusive access to the database

agriff98

No, I am not using databound controls.