Mike and Doris Manning
mikedorism at ntelos.net
Wed Feb 26 20:22:01 CST 2003
And I am countering by stating factually that the author of the article did not take into account that this problem also exists in an ADP. 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 Chris Mackin Sent: Wednesday, February 26, 2003 04:33 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access 2002 database format BUT, what we're talking about is Bloat that "You cannot stop the database bloat when you compact the database." and in the article it clearly states that it only applies to .mdb's. The obvious implication being that it does not apply to .adp's and that the article is only about bloating to a table in an .mdb that DOES NOT go away with compacting. So ultimately the article addresses a problem with Access 2002 .mdb's that does not apply to .adp's. Chris Mackin www.denverdb.com Denver Database Consulting, LLC -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Wednesday, February 26, 2003 2: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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com