Compacting creates Copy

[Wet_Blanket]

Greetings,

Whenever I compact my database, it creates a compacted copy of the database (leaving the original database uncompacted). How do I correct this?

Thanks,

WB

 

[Rabbie]

The Compact process works by creating a new file and copying the database into it as it compacts. At the end the new copy is renamed and the original deleted. In your case it sounds as if there is a problem with the delete. I would check that you have delete rights to the folder where your DB is.

 

[Wet_Blanket]

Thanks Rabbie, good suggestion. I double checked my permissions and do have full permissions on the folder, so that isn't causing the issue.

 

[the_net_2.0]

try this: http://www.google.com/#sclient=psy&...=&aql=&oq=&gs_rfai=&pbx=1&fp=f995690be706998f

 

[Wet_Blanket]

Thanks - Google worked:

Issue: Access - Customer is trying to repair and compact his/her database and it creates a compacted db1.mdb file instead


Cause: This is likely due to an upgrade to Office 2003 11.0_3 and all pertinent security patches and compatibility packs

Resolution: The Microsoft (MS) Access features “Compact and Repair” and “Compact on Close” do not work when the MS Access database is on a clustered server and the version of MS Access is from the SMS package Office2003_11.0_3.0.0 (MS Office 2003 SP3).

A Microsoft provided hot-fix (KB945674) that corrects this problem is currently being evaluated and is tentatively scheduled to be included in the May 2008 Security patch release for Microsoft Office products.