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

Microsoft access/visual basic- database lockout between users

P: 11
receiving error message "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked"

i need to have multiple users being able to access the database at the same time
Feb 20 '07 #1
Share this Question
Share on Google+
9 Replies


Expert 5K+
P: 8,434
receiving error message "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked"

i need to have multiple users being able to access the database at the same time
It sounds as though a user has it opened for exclusive access. Are people likely to be using it directly through MS Access, or only through your application (assuming there is an application)?

I believe you can set an option in Access that determines whether the default action is to open databases exclusively, or shared. If you're using VB (if so, what version?), then you use a parameter when you open the database to specify whether it is for exclusive use.
Feb 20 '07 #2

P: 11
It sounds as though a user has it opened for exclusive access. Are people likely to be using it directly through MS Access, or only through your application (assuming there is an application)?
THE APPLICATION IS OPENED FROM THE DESKTOP USING A SHORTCUT CREATED FROM AN ACCESS MACRO WHICH DOES OPENFORM OPERATION

I believe you can set an option in Access that determines whether the default action is to open databases exclusively, or shared. If you're using VB (if so, what version?), then you use a parameter when you open the database to specify whether it is for exclusive use.
VB 6.3 HOWEVER MY FILES ARE OPENED BY THE FORM
Feb 21 '07 #3

Expert 5K+
P: 8,434
THE APPLICATION IS OPENED FROM THE DESKTOP USING A SHORTCUT CREATED FROM AN ACCESS MACRO WHICH DOES OPENFORM OPERATION

...

VB 6.3 HOWEVER MY FILES ARE OPENED BY THE FORM
Ok, now you've lost me completely. If you are using an Access macro to open an Access form, then where does VB6 come into it?


Ahah! Now I get it. This is VBA version 6.3, built into Access. Now it's starting to make a little sense, at least.

I think you need to check your Access settings (Tools | Options | Advanced) for that database to see whether it is being opened for exclusive use by default.
Feb 21 '07 #4

Expert 5K+
P: 8,434
Since this appears to be largely an Access problem rather than VB, I'm going to move this to the Access forum - we should find more help there.
Feb 21 '07 #5

P: 11
DEFAULT OPEN MODE = SHARED
DEFAULT RECORD LOCKING = NO LOCKS
OPEN DATABASE USING RECORD LEVEL LOCKING IS CHECKED
DEFAULT FILE FORMAT = ACCESS 2000



Ok, now you've lost me completely. If you are using an Access macro to open an Access form, then where does VB6 come into it?


Ahah! Now I get it. This is VBA version 6.3, built into Access. Now it's starting to make a little sense, at least.

I think you need to check your Access settings (Tools | Options | Advanced) for that database to see whether it is being opened for exclusive use by default.
Feb 22 '07 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
DEFAULT OPEN MODE = SHARED
DEFAULT RECORD LOCKING = NO LOCKS
OPEN DATABASE USING RECORD LEVEL LOCKING IS CHECKED
DEFAULT FILE FORMAT = ACCESS 2000
These settings should allow the database to be opened in multiple locations (although I would recommend change Default Record Locking to Edited Record).

Back to your problem. Do you know which machine has it open at the moment. Is there any problem with that machine? Have you tried to close the database on that machine?

Mary
Feb 23 '07 #7

ADezii
Expert 5K+
P: 8,638
receiving error message "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked"

i need to have multiple users being able to access the database at the same time
__1 You will get this exact message when you have a Database Opened and an Object contained within it, say a Form, is in Design View. If you now try to open another Instance of this Database you'll get "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked"
__2 If that is not the problem, close the Database and see if you have a .ldb file with exactly the same base name as the DB e.g. Employees.mdb ==> Employees.ldb. If this file exists once the Database has been closed, deleted it.
Feb 23 '07 #8

P: 19
receiving error message "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked"

i need to have multiple users being able to access the database at the same time

Hi did u finally get the solution to this problem? coz am also experiencing the same problem
Feb 23 '07 #9

NeoPa
Expert Mod 15k+
P: 31,494
If you read through the posts and you'll find the solution :confused:
Feb 23 '07 #10

Post your reply

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