[AccessD] Keeping your db in tiptop shape

The mysterious db1.mdb is the copy of the file created when the file does the compact repair.  The 
process is:

Create a temporary file called dbX.mdb.  X will be the next available number if there is already 
(for example) a db1.mdb.

Copy everything from the named db file into the temp file.

Delete the regular (named) file.

Rename dbX.mdb to the original name.

The file is left behind when the delete of the named file fails for some reason.  This means BTW 
that the compact / repair failed on that occasion.

John W. Colby
www.ColbyConsulting.com


Dan Waters wrote:
> Yes - I've seen where compacting on close will leave behind a file called
> db1.mdb.  But I've only seen that happen when my FE file closes, not the BE
> file which closes automatically.  
> 
> I'm guessing that the db1.mdb file serves some purpose.  When I've seen it
> appear it will typically disappear a second or so after the closing FE.mdb
> file closes.  But once in a while it will not disappear.  
> 
> Dan
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Tuesday, April 14, 2009 1:09 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Keeping your db in tiptop shape
> 
> Dan, do you find that the compact on close leaves temporary files behind? 
> This is supposed to be a problem, but not one I've experienced myself.
> 
> Susan H.
>> 1) Set your BE.mdb file to 'Compact on Close' in Options | General.
>