Unwanted database backup is created

  • Thread starter Thread starter jaworski_m
  • Start date Start date
J

jaworski_m

Hello,
When I close my database (myDataBase.mdb) an unwanted database copy is
created (created filename: db1.mdb).Next time I close db2.mdb is created and
so on...

When I open the same database in a different location this additional file
is not created.
How can I prevent creation of additional file?

Thank you for suggestion.

Access 2003
Win XP.
 
On Thu, 12 Mar 2009 02:06:01 -0700, jaworski_m

That might happen if "compact on close" is on. Check the help file for
how to turn that off.
Or some smart process monitoring your db activities. Check your
Scheduled Tasks.

-Tom.
Microsoft Access MVP
 
You need read/write and delete permission on the folder where this is
happening. It seems as if you have compact on quit turned on.

If so, and you DO have delete permission on the folder then there may be
some corruption in your database and compact is not successfully completing.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Yes, I have read/write permissions.
Click to expand...

You need create (which you must already have) and delete permissions.

When Acce3ss does a Compile & Repair, it creates a new file, copies
over current data and objects, then deletes the old file, and renames
the new .mdb to the old name. Therefore the new file gets left in the
directory....
 
Thank you for the answer.

I also have delete permission on the folder (I can delete the "unwanted"
db.mdf file that was created on On compact & repair)
 
Thank you for your anser.
That's correct."compact on close" is on.

How can I avoid the creation of the unwanted "backup" file when I close my db?
I'd like "compact on close" to be on.
I have all necessary permissions on folder (read/write/delete).
 
Back
Top