Mike and Doris Manning
mikedorism at ntelos.net
Wed Feb 26 20:19:00 CST 2003
Right... It is BLOAT because it does not get released during a normal compact and repair. You must pull everything into a new container in order to get rid of the extra 10MB+ weight that builds up over time. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Wortz, Charles Sent: Wednesday, February 26, 2003 04:01 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access 2002 database format Doris, That is not bloat. That is the normal action of Access when it needs temporary space that it then releases when it is through with it. Bloat is when it grabs space and does not release it when it is no longer needed. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] Sent: Wednesday 2003 Feb 26 14:57 To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access 2002 database format There may not be any tables but the bloat still applies... I have one ADP that balloons up to 38MB and then shrinks down to 25MB when I pull everything into a new container. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com