Charlotte Foust
cfoust at infostatsystems.com
Wed Feb 26 15:14:00 CST 2003
Charles, I was under the impression that was the *definition* of bloat. Doris did point out that she only recovered the space when she copied into a new container, not just when she closed and reopened the adp. Charlotte Foust -----Original Message----- From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] Sent: Wednesday, February 26, 2003 1: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