Cannot compact/repair db because file is already in use

B

Blair Westman

I am having trouble compacting my db and the system tells me that my db is in
use. However, I know for a fact that I am the only person using the db on
the network. Has anybody ever encountered this problem?

Thanks for your help,
Mia
 
J

John Vinson

On Wed, 21 Dec 2005 11:40:05 -0800, "Blair Westman" <Blair
I am having trouble compacting my db and the system tells me that my db is in
use. However, I know for a fact that I am the only person using the db on
the network. Has anybody ever encountered this problem?

Thanks for your help,
Mia
Click to expand...

If there is a .ldb file in the same folder as the .mdb file, with the
same filename, delete it first. This is a "lock" file created when you
open the database; it should be deleted when you close, but sometimes
isn't if you exit the database abnormally.

You can also compact the database without opening it using the command
line switch: in the Windows Start... Run menu type

msaccess.exe "X:\PathToYourDatabase\yourdata.mdb" /Compact

using your own disk, path,and filename of course.

John W. Vinson[MVP]
 
Top