Dan Waters
dwaters at usinternet.com
Mon Oct 27 12:37:13 CST 2003
Thanks Charlotte! Just what I needed to know. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Monday, October 27, 2003 11:11 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Compacting on FE and BE If the FE is local and autocompact is set on, the front end gets compacted when you close the database. If the front end is shared, it gets compacted when the last person leaves it, same as the back end. Charlotte Foust -----Original Message----- From: Dan Waters [mailto:dwaters at usinternet.com] Sent: Sunday, October 26, 2003 7:49 AM To: Database Advisors Subject: [AccessD] Compacting on FE and BE I've been wondering . . . In a configuration where the system is split FE and BE, and the FE also has local tables that are used for temporarily holding data, how are the local tables compacted? Particularly in Access XP when it's set to auto-compact? I know that the BE is compacted when the last person exits. Thanks! Dan Waters Quality Process Solutions _______________________________________________ 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