Two or More Users Can't Open DB at Same Time

[crhodus]

I have put a database out on the network so that multiple users can add, edit, or delete record.

If I leave the database open on my computer and then try to open the database on another computer, I get a message that says someting like "The database has been placed in a state by user 'admin' on machine 'xxxxx' that prevents it from being opened or locked."

I'm assuming that the first computer to open the DB has opened the file in exclusive mode. What do I need to do/change in order for two or more users to be in the database at the same time?

Thanks!

 

[Pat Hartman]

If any user opens the db and makes changes to objects (as opposed to changes to data), all other users are effectively blocked from opening the db.

If you need to make changes to the db, make them to your own copy. Then replace the shared server fe with the changed copy.

 

[ghudson]

Do all of the users have the neccessary network persmissions to add, edit and delete files within the directory that the db sits?

Each user must be able to create, edit and delete the .ldb [record locking] file. The .ldb file si automatically created when the first user has opened the db. The next users will edit the .ldb file and the last user to close the db [Access] will delete the .ldb file.

HTH

 

[crhodus]

Everyone should be able to add, edit, and delete files for this directory. I've tried testing this with two different databases and I am experiencing the same problem

I have my database split so that there is a FE and and BE. I have also checked each computer to ensure that the Default Open Mode is set to Shared. The Default Record Locking mode is set to No Locks.

I have not set up any user and group accounts\permissions for this database.

I'm using Access 2000, Win 2k, and Win98.

 

[RichMorrison]

This is what you do:

1) open the FE data base
2) go to the Tools menu
3) select the Security item
4) select "User and Group Permissions"
5) select "Database" from the list box
6) select "Groups" from the radio button
7) select the group named "Users"
8) uncheck the option boxes for "Open Exclusive" and "Adminisitr"
9) close

Done

RichM

 

[crhodus]

Rich,

I made the changes that you suggested, but I'm still experiencing the same problem.

So far, the only way I've been able to have 2 or more users run the program is to give each user a copy of the front end. This is not what I really want to do, but at least it works.

 

[Pat Hartman]

Have some user open the Access db when you know that no one else is using it. Does the .ldb file appear in the database's directory?

 

[crhodus]

No one else has the db open. Also, when I am using the database, there is a .lbd file that is created for my front end and a .lbd for my back end.

I'm the only one using the database. If I leave the database open on my computer and then try to open the database on another computer, that's when I receive the error.

 

[crhodus]

I finally got the database to open on 2 different machines at the same time. I had to go into Add/Remove Programs, select Microsoft Office 2000 Professional and click on the Change button.

Once the MS Office 2k setup screen loaded, I clicked on Add or Remove features. From there, I selected Access and changed the setting from "Run on Network" to "Run from My Computer". So far, it seems to be working correctly now.

Thanks for everyone's help!!