[AccessD] Compacting on FE and BE

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