Charlotte Foust
cfoust at infostatsystems.com
Thu Nov 4 10:14:14 CST 2004
The uncompressible bloat occurs in a system table that doesn't exist in the 2000 format, which is why we use that format for our data mdbs. We use the 2002 format for the front ends. As long as some of our users want to be able to use A2k or VB6 to work with the file, 2000 is the preferred data format for us. Charlotte Foust -----Original Message----- From: Erwin Craps - IT Helps [mailto:Erwin.Craps at ithelps.be] Sent: Wednesday, November 03, 2004 10:54 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2K3 Bloating You can set the default DB type for new database between 200O or 2002/2003 in the option menu. On my computer it is set tp 2002/2003, it is posible that I changed it to 2002/2003 but I don't see the point having A2K3 and creating by default new databases in 2000 format, seems pointless to me. I'll check on my other computers, if I did changed that option, than probably not on the those. You can work and modify 2000 dababase files without converting in Access 2003. Maybe the bloat is still present in A2K3 when using A2K database. Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, November 04, 2004 2:33 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2K3 Bloating Are you sure? I understood that A2K3 used the 2000 format by default. Charlotte Foust -----Original Message----- From: Erwin Craps - IT Helps [mailto:Erwin.Craps at ithelps.be] Sent: Wednesday, November 03, 2004 4:27 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2K3 Bloating Charlotte As far as I know A2K3 uses the 2002/2003 format by default. Maybe I changed it once in the options don't kown for sure, but anyway I did not experianced some bloating in 2002/2003 format... But I must confess I did not do any heavy developing yet in A2K3, I only switched one major and big app recently from A2K to A2K3. Now I just started a new app in A2K3, but I only started that yet... Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, November 03, 2004 9:27 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2K3 Bloating As far as I know, the problem still exists in 2003, and the 2000 format is still the default in that version. Charlotte Foust -----Original Message----- From: Jim DeMarco [mailto:Jdemarco at hudsonhealthplan.org] Sent: Wednesday, November 03, 2004 11:02 AM To: AccessD (E-mail) Subject: [AccessD] A2K3 Bloating List, Has M$ addressed the database bloating issue in A2K3 I've read about on the list? We're in the process of converting our A97 apps to A2K3 and I'm trying to decide between A2K format or A2K3. Any suggestions? TIA, Jim DeMarco Director Application Development Hudson Health Plan Tarrytown, NY ************************************************************************ *********** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ************************************************************************ *********** -- _______________________________________________ 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