By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,967 Members | 1,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,967 IT Pros & Developers. It's quick & easy.

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

P: 76
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.
Jan 24 '08 #1
Share this Question
Share on Google+
2 Replies


Dököll
Expert 100+
P: 2,364
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
Jan 24 '08 #2

P: 76
It is on a shared network drive. I'm not sure why it keeps people out, while someone else has it open.
Jan 25 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.