Help with "compact on close"

[Michele]

Using Access 2000 on Windows 2000...

I have an Access database file with the "compact on close" option
selected. When I close the .mdb file, I INTERMITTENTLY get the error
that

"Microsoft Access can't delete <<my database>> after compacting it.
The compacted database has been named db1.mdb."

The message goes on to say that the original database wasn't deleted
because it is read-only.

I've seen other posts like this one, but none fixes my problem!

Some facts:
-The database file is NOT read only.
-I can delete this file from the directory by hand, therefore it
would appear not to be a rights issue on the directory or file

Any help is much appreciated!!

 

[Liz]

We have gotten a similiar error when two people have the
database open at the same time, one closes, and the
compact on close attempts to run....since the db is still
essentially open Access creates the db1, because it
actually can't delete the one that is still open on
someone else's desktop.

 

[Randy Harris]

Using Access 2000 on Windows 2000...

I have an Access database file with the "compact on close" option
selected. When I close the .mdb file, I INTERMITTENTLY get the error
that

"Microsoft Access can't delete <<my database>> after compacting it.
The compacted database has been named db1.mdb."

The message goes on to say that the original database wasn't deleted
because it is read-only.

I've seen other posts like this one, but none fixes my problem!

Some facts:
-The database file is NOT read only.
-I can delete this file from the directory by hand, therefore it
would appear not to be a rights issue on the directory or file

Any help is much appreciated!!

Michele, I've run into the identical problem and also am looking for a
solution. Two users have complained (out of about 80), the only thing that
I can find in common between the two, is that they both like to keep many
applications open.

 

[Liz]

Randy and Michele,
Please both check to make sure there are not two people
with the application open at the same time, and one is
attempting to close.

 

[Van T. Dinh]

When Access compacts a database, it actually creates a new database then
compact objects from the old database to the new database. Upon completion,
Access deletes the old database and rename the new database with the old
name. When there is another user still using the database, you get the
above error message.

If you have a multi-user database, you should (MUST, really) split the
database into Front-End and Back-End. The Back-End only contains Tables and
resides on a shared network drive so that all users can access the Tables.
The Front-End contains all other Access Object and each user should have a
copy of the Front-End on his / her desktop. Set the Front-End to
Compact-On-Close.

This way, the user only compact his / her independent copy of the Front-End.
Since most processing is done in the Front-End where temporary space is
created, you only need to Compact the Front-End regularly. The Back-End can
be compacted manually once in a while (I normally compact the Back-End once
a month).