Dan Waters
dwaters at usinternet.com
Tue Apr 14 13:49:38 CDT 2009
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