Database engine can't lock table??
Database engine can't lock table??
(OP)
I have a table in Access 2000 that I cannot open or delete. When I try to delete it I get this msg:
"The database engine could not lock table because it is already in use by another person or process"
I am the only user, I have re-installed several times and it won't go away.....Please help
"The database engine could not lock table because it is already in use by another person or process"
I am the only user, I have re-installed several times and it won't go away.....Please help
RE: Database engine can't lock table??
Kathryn
RE: Database engine can't lock table??
RE: Database engine can't lock table??
With Access off, go and find the .LDb that may be sitting beside your database. Delete it. (It is rebuilt each time the Db is opened.)
Look through the table for what I would call a "jammed" record: could be in any field, and usually says #deleted#.
If you find one like this it is holding up the whole mess. You can try to delete it or try to copy all the other records to another table (not a fun process...) Good luck,
Gord
ghubbell@total.net