[AccessD] Access 2002 database format

Charlotte Foust cfoust at infostatsystems.com
Wed Feb 26 14:15:00 CST 2003


But what exactly does it mean?  Does this only occur if you add and
remove the objects themselves?  What happens when you add or remove code
from within the objects?
 
Charlotte Foust

	-----Original Message-----
	From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] 
	Sent: Wednesday, February 26, 2003 12:10 PM
	To: accessd at databaseadvisors.com
	Subject: RE: [AccessD] Access 2002 database format
	
	
	Speaking from experience, it is also a concern for ADP files.
	 
	
	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 Susan Zeller
		Sent: Wednesday, February 26, 2003 02:16 PM
		To: accessd at databaseadvisors.com
		Subject: RE: [AccessD] Access 2002 database format
		
		
		The article says it only applies to MDB's.  Does that
mean this is not a concern for ADP files?
		 
		--Susan
		 

			-----Original Message-----
			From: Dan Waters [mailto:dwaters at usinternet.com]

			Sent: Wednesday, February 26, 2003 8:54 AM
			To: accessd at databaseadvisors.com
			Subject: RE: [AccessD] Access 2002 database
format
			
			
			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/00d7bab7/attachment-0001.html>


More information about the AccessD mailing list