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!

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

Database locked by user ...

Status
Not open for further replies.

dale66

Programmer
Jun 18, 2001
5
0
0
US
Occassionally users of our program get a message during program startup similar to: "Database is currently locked by user 'admin' on machine 'Dale'". Our application does not lock the database. The database is MS-Access, the program is Visual Basic 5.0 and we are using MS-JET4.0 to access the database.

I read in the Microsoft-Access-General Discussion forum that one way to fix this problem is the delete the .ldb file and that Access automatically deletes this file when the last connection closes.

How do I get our program to delete the .ldb file when it exits?
 
Another possibility is that a user has opened the table in design view inside MS Access. This will lock the table.

Chip H.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top