cannot compact db - file in use error message

[Stef]

In Access 2000 (Premium), when I try to compact db, the Jet 3045 Error
appears: Could not use <filename>; file already in use.
I use a separate script to insert data into it, but it closes all the
connections & object references after it's all done. That has not happened a
few times though when it crashed during development but should not be a cause
since I restart my PC...
The file is not shared with any other PCs. And its size is now 109 MB!
I'm sure there must be someone to help me!
Thanks.
Stef

 

[Scott McDaniel]

Your database could be corrupt, or moving that way. Try moving your objects
to a new, blank database (open a new database, click File - Get External
Data and follow the prompts) and see if the problem goes away.

 

[Arvin Meyer]

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Nikos Yannacopoulos]

Stef,

Since the db crashed, eventhough you restarted the PC afterwards, the
lock file must have remained there, and is causing this problem, Look in
the folder where the db is saved for a file with the same name,
extension .ldb; delete it (while no user is actually in the database)
and the problem will be solved.

HTH,
Nikos