<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=021441020-26022003><FONT face="Comic Sans MS" color=#0000ff
size=2>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?</FONT></SPAN></DIV>
<DIV><SPAN class=021441020-26022003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=021441020-26022003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Mike and Doris
Manning [mailto:mikedorism@ntelos.net] <BR><B>Sent:</B> Wednesday, February
26, 2003 12:10 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Access 2002
database format<BR><BR></FONT></DIV>
<DIV><SPAN class=822190920-26022003><FONT face=Arial color=#0000ff
size=2>Speaking from experience, it is also a concern for ADP
files.</FONT></SPAN></DIV>
<DIV><SPAN class=822190920-26022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=822190920-26022003>
<DIV align=left><FONT face=Arial size=2>Doris Manning</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Database Administrator</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Hargrove Inc.</FONT></DIV>
<DIV align=left><FONT face=Arial color=#0000ff
size=2><U>www.hargroveinc.com</U></FONT></DIV></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com] <B>On Behalf Of </B>Susan
Zeller<BR><B>Sent:</B> Wednesday, February 26, 2003 02:16 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Access 2002
database format<BR><BR></FONT></DIV>
<DIV><SPAN class=779181519-26022003><FONT face=Arial color=#0000ff
size=2>The article says it only applies to MDB's. Does that mean this
is not a concern for ADP files?</FONT></SPAN></DIV>
<DIV><SPAN class=779181519-26022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=779181519-26022003><FONT face=Arial color=#0000ff
size=2>--Susan</FONT></SPAN></DIV>
<DIV><SPAN class=779181519-26022003></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Dan Waters
[mailto:dwaters@usinternet.com] <BR><B>Sent:</B> Wednesday, February 26,
2003 8:54 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
RE: [AccessD] Access 2002 database format<BR><BR></FONT></DIV>
<DIV><SPAN class=911374814-26022003><FONT face=Arial color=#0000ff
size=2>Charlotte - Here is something to be aware of.</FONT></SPAN></DIV>
<DIV><SPAN class=911374814-26022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=911374814-26022003>Microsoft Knowledge Base
Article - 810415 </SPAN></DIV>
<DIV><SPAN class=911374814-26022003>Access 2002 Format Database Bloat Is
Not Stopped by Compacting</SPAN></DIV>
<DIV><SPAN class=911374814-26022003></SPAN> </DIV>
<DIV><SPAN class=911374814-26022003><FONT face=Arial color=#0000ff
size=2><A
href="http://support.microsoft.com/default.aspx?scid=kb;en-us;810415">http://support.microsoft.com/default.aspx?scid=kb;en-us;810415</A></FONT></SPAN></DIV>
<DIV><SPAN class=911374814-26022003><FONT face=Arial color=#0000ff size=2>
<DIV><SPAN class=911374814-26022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=911374814-26022003><FONT face=Arial color=#0000ff
size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN
class=911374814-26022003></SPAN> </DIV></FONT></SPAN></DIV>
<DIV><SPAN class=911374814-26022003><FONT face=Arial color=#0000ff
size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=911374814-26022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=911374814-26022003><FONT face=Arial color=#0000ff
size=2>Dan Waters</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com] <B>On Behalf Of
</B>Charlotte Foust<BR><B>Sent:</B> Tuesday, February 25, 2003 2:38
PM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] Access 2002 database format<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face="Comic Sans MS" size=2>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.</FONT></P>
<P><FONT face="Comic Sans MS" size=2>Charlotte Foust</FONT>
</P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>