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