Dan Waters
dwaters at usinternet.com
Wed May 7 16:38:33 CDT 2003
OK - true. But the AXP formatted database will bloat, and compacting won't reduce the size. If the database is in A2K format in the first place, that problem doesn't happen, and the database does reduce to minimum size after compacting. For an existing database in AXP, moving all the objects into an A2K formatted database will solve the problem for good. I have experienced this problem. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, May 07, 2003 2:47 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Upgrading to Access 2002 from A2K - KB 810415 I haven't encountered any problems compacting XP format databases. The problem is not that you can't compact, it's that a system table exists in 2002 that may not reduce in size when you compact. The workaround is to create a new database and import all the objects into it. Charlotte Foust -----Original Message----- From: Dan Waters [mailto:dwaters at usinternet.com] Sent: Wednesday, May 07, 2003 11:51 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Upgrading to Access 2002 from A2K - KB 810415 Oops! The problem is compacting, not decompiling. I guess age 46 must have been the good memory threshold! The KB article is at: http://support.microsoft.com/default.aspx?scid=kb;en-us;810415 The effect is the same - you should use the A2K format when creating AXP mdb's. Apologies!! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman Sent: Wednesday, May 07, 2003 12:39 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Upgrading to Access 2002 from A2K ...first time I'd heard of this decompile bug in XP Dan ...its not my experience ...do you have any references you can share? William Hindman ----- Original Message ----- From: "Dan Waters" <dwaters at usinternet.com> To: <accessd at databaseadvisors.com> Sent: Wednesday, May 07, 2003 1:29 PM Subject: RE: [AccessD] Upgrading to Access 2002 from A2K > Mark, > > There is a recognized bug in AXP that prevents decompiling an mdb. However, > if you set the mdb format to A2K when you develop in AXP, you will > still be > able to decompile. You can choose A2K to be the Default File Format > in Tools | Options - Advanced before creating a new database. > > Other than that, I am pretty satisfied with AXP. I've had an > occasional crash, but nothing I would consider a problem. I am, > however, an avid control-s guy! > > Dan Waters > Quality Process Solutions > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Whittinghill > Sent: Wednesday, May 07, 2003 11:51 AM > To: accessd at databaseadvisors.com > Subject: [AccessD] Upgrading to Access 2002 from A2K > > > Hi all, > > Recently my computer died due to power source failure, though I was > able to recover files later. I was due to upgrade my computer here > anyway, so I > now have a new computer with Windows XP, the old one was Windows 2000. > We have yet to do any work in Access 2002. Some of our clients use > that, but we just send Access 2000 versions. > > I never used to have problems with Access 2000, though I have read > many posts from people who had. Now that I have Windows XP, I am > having crashes > all the time, with the "Send Error Report" dialog box. Twice in the > last couple weeks I have had things get corrupted so bad that I just > had to restore my file from an earlier version and flush my work for > the day down the toilet. Based on what I am hearing of Access 2002, I > am thinking that I > should just upgrade to that, even though I work in 2000 file format. > Are there any downsides to doing that? Thanks for any advice. > > Mark Whittinghill > Symphony Information Services > 612-333-1311 > mwhittinghill at symphonyinfo.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