What's <db name>1.mdb?

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

A couple of times, maybe 3 or 4, I've found a database with my database's
name plus a 1 in the same folder. It's obviously a copy. Where does it
come from? It has the same date as the "real" one.
 
Do you have CompactOnClose turned on?

When Compacting On Close, Access creates a new copy of the current db named
db+1. *If* the compact was successfully completed it then deletes the old
file and renames the new. This provides the illusion that you have compacted
to the same file you started with but Access has really been juggling 2
files.

Seeing a <yourDB>1 file may be nothing more than an unsuccessful compact
where the 'new' (and possibly incomplete...?) file never got to the renaming
stage. That happens occasionally and isn't anything to worry about as long
as you've been able to do a subsequent compact.

HTH,
 
Thanks much.

George Nicholson said:
Do you have CompactOnClose turned on?

When Compacting On Close, Access creates a new copy of the current db
named db+1. *If* the compact was successfully completed it then deletes
the old file and renames the new. This provides the illusion that you have
compacted to the same file you started with but Access has really been
juggling 2 files.

Seeing a <yourDB>1 file may be nothing more than an unsuccessful compact
where the 'new' (and possibly incomplete...?) file never got to the
renaming stage. That happens occasionally and isn't anything to worry
about as long as you've been able to do a subsequent compact.

HTH,
Click to expand...
 
Back
Top