[AccessD] Access 2002 database format

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





More information about the AccessD mailing list