Compact on Close db1

[Guest]

I was using the compact on close option on my FE, but access keeps removing
the origional FE and replacing it with a copy database called db1.

Any reason this is happening?

 

[Arvin Meyer]

db1 is the default name that Access creates. Actually a compact rewrites the
data into a new empty database named db1.mdb. It then checks it for errors
and finding none will delete the original and rename db1 to the orignal's
name. Something is interupting the process. I suggest you carefully back up
your database (several copies) and manually compact to make sure it isn't
corrupt.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

hi
on 7/28/2005 6:40 PM PST there was a similar post titled:
compress the database everytime when I quit the database

in there the final solution that was discussed ( and i tested this)

In your Startup Forms , say "MainMenu", in OnOpen Event in this form:
Application.SetOption "Auto Compact", True

this will guarantee to reset the auto compact every time you open a
particular database.

sam