Compact and Repair Utility

[Jonathan]

Hello all

I'm running Access 2003 on WinXP Home version on a small (340K) database. I've
had no problems until today. I have the compact on close flag set. When I
tried to exit the database I got the following message:

===================

Microsoft Office Access can't delete <path>\Accounts.mdb after compacting
it. The compacted database has been named <path>\db1.mdb

If you compact a database using the same name, Microsoft Office Access
creates a new compacted database and deletes the original. In this case,
however, the original database wasn't deleted because it is read-only.

If you can, remove the read-only status, delete the original database and
then rename the new database using the original name. If you can't remove
the read-only status, inform your workgroup administrator.

====================

I checked the file properties of the original database and it was not marked
read-only. I created a copy of the database (copy/paste) and I was able to
run the compact/repair utility without error.



This is kind of spooky. Why would Access think the DB was read-only? What
can I do to prevent this?



Thanks

Jonathan

KingsKnight1 <at> hotmail <dot> com

 

[Arvin Meyer]

More than likely it was the Windows file system not releasing the LDB file
quickly enough. When this happens the file system thinks the database is
still open and in use and cannot delete it. Thus the error message. If it
keeps happening, it is either another problem, or it is possible that you
need to speed up your system. You can do that by defragmenting your hard
drive and by closing any unneeding programs.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access