[AccessD] Access 2002 database format

Dan Waters dwaters at usinternet.com
Wed Feb 26 08:55:01 CST 2003


Charlotte - Here is something to be aware of.
 
Microsoft Knowledge Base Article - 810415 
Access 2002 Format Database Bloat Is Not Stopped by Compacting
 
http://support.microsoft.com/default.aspx?scid=kb;en-us;810415
 
The KB article describes a system table in XP that is not compacted when
it should be.  Microsoft confirms that this is a problem and they
recommend developing using the 2000 format when you can.
 
I was developing an ~ 15 Mb database in 2002 format, but it bloated to 3
- 4 times this size, and decompiling/compacting didn't shrink it.  I
moved all the objects to a 2000 db file, and then was able to get it
back down to the normal size.  
 
Dan Waters

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Tuesday, February 25, 2003 2:38 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Access 2002 database format



Does anyone know of reasons to chose the 2002 format over the default
2000 format, or vice versa, in AXP?  I can't think of any reason except
to be able to create an mde, which we can't do with our app anyhow
because of the design changes it makes to itself at runtime.

Charlotte Foust 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030226/a9ae6553/attachment-0001.html>


More information about the AccessD mailing list