upgrade to Access 2003 = no exclusive permission to database

[Benjaminle]

I just upgraded Access 2000 to Access 2003 for 20 clients. Some of them received the error message "you do not have exclusive access to the database at this time..".. I have to force shutdown to close out Access. I just can't figure out why my some clients are running access 2003 and are able to open the same database just fine while some are not.

 

[PHV]

Are some of the users going in design view ?
If yes then they lock the database for exclusive access.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Benjaminle]

No, the no user are in desgn view. This is a database that could be opened by many users. It was working fine when everyone was using Access 2000. Now that I upgraded half of the users to Access 2003, they have this problem when logging in to the database. Strange thing is, only a few users with Access 2003 have this problems while other user with Access 2003 do not.

 

[Benjaminle]

Another thing I noticed was when the database was opened, a ldb file was created and it has the picture of a lock on it. My workaround was telling the end-user to open MS Access 2003 first, then go to File, Open, then browse to the database and this would open just fine. But if I double click on the database directly, then I get that error about
"you do not have exclusive access to the database at this time"