Problem with my database being placed in a state by a user.

[Briansmi1116]

I have a database that I created to be used by several people on a network. Every now and then, when someone has it open, and another wants to open it they get this error; "The database has been placed in a state by user <name> on machine <name> that prevents it from being opened or locked. (Error 3734)."

Is there a reason this is happening, because I can sometime access the database when the same person has it open. Is there somethin I can put in V Basic to either save what ever has been changed or a setting I might be missing?

I like to thank you in advance for the help.

[Dököll]

I have a database that I created to be used by several people on a network. Every now and then, when someone has it open, and another wants to open it they get this error; "The database has been placed in a state by user <name> on machine <name> that prevents it from being opened or locked. (Error 3734)."

Is there a reason this is happening, because I can sometime access the database when the same person has it open. Is there somethin I can put in V Basic to either save what ever has been changed or a setting I might be missing?

I like to thank you in advance for the help.

Hello, Briansmi1116!

Is the database on a shared drive?

It could just be a network error or burb, temporary and can be fixed by rebooting.

Access databases, I believe, should not keep your users from loggin in, Excel does that.

Also, did you add this database to user machines as a user or admin, that could have some unfriendly effects.

Have a look tom see;-)

Sorry for your troubles.

Dököll

[Briansmi1116]

It is on a shared network drive. I'm not sure why it keeps people out, while someone else has it open.