I have the same problem with my Access 97 DB. The locking file will not close and it cannot be deleted. If I right click on the "ldb" file and open it with notepad, it will show that I have it open even though I don't have it open. It is possible to copy the mdb file to another...
Thanks th3856, for this tip, I have wondered about this because that open "LDB" file often keeps me from compacting the backend or updating my "mde" copy.
I hope someone responds to this because I have the same problem with a record in one of the tables in one of my DataBase/programs at work. I can change the data in the record but cannot delete it. Also, a query designed to count those records for a pop up box will not count that particular...
WP - Thanks for the response. I think you're right about that because I did try to import the tables and could import all but 1 table. Every attempt to import that 1 table gave an error message that the Microsoft Database Jet Engine could not complete the action because someone else was trying...
I cannot compact, repair or even look at the tables in the backend of my split database. I get the error message: "operation is invalid without a current index" or " "" isn't an index in this table. Look in the Indexes Collection of the TableDef to determine valid index...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.