[AccessD] Keeping your db in tiptop shape

Charlotte Foust cfoust at infostatsystems.com
Tue Apr 14 15:04:52 CDT 2009


The db1 file is the file your database was compacted to.  Behind the
scenes the process is compact to a temp name, delete the original and
rename the temp file.   When it can't delete the original, it can't
rename the temp file and that gets left hanging out there.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Tuesday, April 14, 2009 11:50 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Keeping your db in tiptop shape

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.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list