Myke Myers
mmmtbig at bellsouth.net
Thu Feb 27 08:36:00 CST 2003
In one of my Access 2000 ADP projects there are 19 hidden sys... tables. I haven't converted it to Access 2002. Myke -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Dan Waters Sent: Wednesday, February 26, 2003 10:25 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access 2002 database format In your ADP can you go to Tools|Options|View and select System Objects? If you can does the table MSysAccessStorage become visible in the tables view of the db window? ADP might be storing info about the modules in this system table, which remains in the ADP instead of SQL Server. The table that is bloating is not a data table, but a system table. Dan Waters -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Mike and Doris Manning Sent: Wednesday, February 26, 2003 8:26 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access 2002 database format An ADP is not supposed to have any tables. The meat of the database is supposed to reside in the server (in my case SQL Server 2000) that you are connected to. What you are saying might make sense if and ADP was somehow storing info somewhere outside of that connection. According to MS documentation that is not supposed to be the case. 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 Dan Waters Sent: Wednesday, February 26, 2003 06:19 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access 2002 database format 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 _______________________________________________ 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