[AccessD] ACC97 Repair and Compact

I'm thinking that you'll need to follow the suggestion to force the users
out of the database, just closing it down around their ears if they don't
get out.  Unfortunately people go home and leave things open.  No way out
but to force a close.

Once everyone is out, just do the compact.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tony Septav
Sent: Sunday, November 02, 2003 1:43 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] ACC97 Repair and Compact


Hey All
Thanks John and William for your quick responses.
John this has to be a  no brainer (as far as the  employees are
concerned), as I already had a repair and compact option available when
they closed the frontend, but nobody  bothered to close the front end or
use the option (tried a warning also).
William I have looked at Dev's site, I will have to figure out how to
incorporate the repair and compact of the backend in the same routine.
I assume the Jet Repair/Compact utility is available from Microsoft.
Thanks again

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