[AccessD] Keeping your db in tiptop shape

In my experience, I've had issues with a A2007 run time and a A2003
file.
Occasionally, it would hang and never complete.  Sometimes it would
leave a copy of the file - usually incomplete.  Once I had to rebuild a
form because it was corrupted.  I've also had to use the "three-finger
salute" to stop the process in the task manager - or maybe it was
impatience that got the best of me.

Jim


-----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
################################################################################
If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of 
this information is prohibited. This email transmission contains 
information from NCI Information Systems, Inc. that may be considered 
privileged or confidential and is intended solely for the named 
recipient.
################################################################################