Compact & Repair ?

[Mick]

Hi,

I have having an issue whereby I am compacting and
repairing my db (named XYZ) and it is automatically
creating a new db (named db1) in the same directory that
XYZ sits? The new db seems to be exactly the same as XYZ
except it is much larger (almost double at 52mb where XYZ
in 28mb). The structure seems to be identical? XYZ
itself seems to be fine but i do not understand why the
duplicate is created?

Any assistance is greatly appreciated.

Regards

Mick

 

[Van T. Dinh]

In a successful Compact and Repair, Access compact your database to a
temporary database "dbX.mdb" (X is the next available number if there are
files with names "db1.mdb", "db2.mdb", ...). When the Repair & Compacting
finishes, Access delete your original file and rename the file "dbX.mdb" to
your original name.

It seems something stopping the full Repair and Compact process near the end
(just before deleting and renaming). Someone reported the same problem
previously but I am not sure whether any solution was offered. Perhaps, you
can search Google for the previous thread.

 

[Joan Wild]

One possibility is if the Windows user doing the compact doesn't have delete
permission in the folder, they can't delete the original mdb.

 

[Dawn]

Mick, I have experienced the same situation as you have
and Van is right on! I have found that if I attempt to
compact and repair on a network drive, the process binds
and quits (and leaves db1 out there in the process). Most
of my database are very small so I copy them to a local
drive, compact and repair, and then move replace the
network copy. I have not yet found a way around this.

Let me know if you do!

 

[Alfred Polak]

Test

In a successful Compact and Repair, Access compact your database to a
temporary database "dbX.mdb" (X is the next available number if there are
files with names "db1.mdb", "db2.mdb", ...). When the Repair & Compacting
finishes, Access delete your original file and rename the file "dbX.mdb" to
your original name.

It seems something stopping the full Repair and Compact process near the end
(just before deleting and renaming). Someone reported the same problem
previously but I am not sure whether any solution was offered. Perhaps, you
can search Google for the previous thread.