Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO database will not open

Status
Not open for further replies.
MrMajik

MrMajik

IS-IT--Management
Apr 2, 2002
267
When I attempt to open a recordset using VB code I get the following error:

"The database has been placed in a state by user 'Admin' on machine 'Steve' that prevents it from being opened or locked."

Am using MS Access 2000. I am not logged in as admin. When I created this database I did not put any locks or controls on it to cause this. What do I have to change the state of this database?

Thank you,
Steve
 
Sort by date Sort by votes
compact the database. If it lets you. If not reboot the machine where the database is stored, then delete the .ldb file and try again.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Question
switch between two open database
Replies
12
Views
535
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
305
dhookom
dhookom
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
841
grnzbra
grnzbra
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
553
lmcate
lmcate
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
264
PizMac
PizMac

Part and Inventory Search

Sponsor

Back
Top