shared access db 2003

[offmyrocker]

I've shared a db on the network, but it keeps opening in exclusive mode, so only one user can enter details at any one time. How can I avoid this?

 

[Remou]

Have you checked that all users have full permissions on the folder in which the back-end is stored? Does each user have their own copy of the front-end?

http://lessthandot.com

 

[missinglinq]

Is this, in fact, a split database?

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[offmyrocker]

All users have permissions to the database and no, it is not a split database...

 

[dhookom]

offmyrocker,
Remou asked if "all users have [red]full[/red] permissions on the folder". You didn't really answer that question. Can every user of the database create and delete files in the folder containing the MDB?

You really should consider splitting your application into front-end and back-end mdb files.

Duane
Hook'D on Access
MS Access MVP

 

[offmyrocker]

All users have full permissions. Why would this be causing the database to go into "exclusive" mode when I open it? Once the database is in eclusive mode, it dosen't matter what permission anyone has, not even an administrator can alter the data, because it keeps going into exclusive mode when I open it...

 

[offmyrocker]

What I have also did as a test, closed the db, got another user to open it, it opened fine. When I then tried to open it, I got the following message:The database has been placed in a state by user 'Admin' on machine "desktoppc" that prevents if from being opened or locked. That was just opeing it as normal to add data.

 

[Remou]

This still looks very like a permissions issue, however, you can:

* Check that the Default Open mode is shared (tools, options, advanced tab).
* Check that there is no code running, you could try holding the shift key down when you open the file and see if the file is still locked.
* Copy and split the database and see if that works - I would strongly urge you to use a split database anyway.

http://lessthandot.com

 

[dhookom]

Do you see an ldb file in the same folder as the mdb? If not, the first person who opened the file will have exclusive use of the mdb.

When I asked

Can every user of the database create and delete files in the folder containing the MDB?

I was hoping you would come back with something like: "All users can successfully create and then delete a simple text file in the folder containing the MDB."

Duane
Hook'D on Access
MS Access MVP