[AccessD] A2K3 Bloating

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



More information about the AccessD mailing list