Dan Waters
dwaters at usinternet.com
Wed Feb 26 17:19:00 CST 2003
Doris, I haven't created any ADPs so forgive this question: Does your ADP file have any hidden tables? From the KB article it sounds like the MSysAccessStorage table keeps track of module code (somehow?), and modules are part of the ADP. So it might make sense that the MSysAccessStorage table is actually in the ADP as a hidden system file. So, does this table exist in your ADP? Thanks Dan Waters -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, February 26, 2003 3:10 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access 2002 database format 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com