[AccessD] A97 or A2002

Charlotte Foust cfoust at infostatsystems.com
Tue Apr 6 12:37:11 CDT 2004


The format is selected on a database basis, but 2000 is the default
format.  You can set the default to 2002, but the database opens in
whatever format you used to create/convert it.  I'll let someone else
address the unicode issue.  

Charlotte Foust

-----Original Message-----
From: Griffiths, Richard [mailto:R.Griffiths at bury.gov.uk] 
Sent: Tuesday, April 06, 2004 8:56 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] A97 or A2002 


Charlotte
Thanks for your reply - I assume you can choose when you load A2002
(AXP) to have 2000 format?  What are the benefits for Unicode - what
other benefits does A2000 have? Thanks


-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com] 
Sent: 06 April 2004 16:22
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] A97 or A2002 

You can use DAO with A2002 (and yes, that is AXP), so that isn't a
problem.  The 97 file format is smaller because it doesn't use unicode,
but I would suggest using the 2000 file format because it does use
unicode and it doesn't have the extra bloat problem that exists in 2002.
The file size will roughly double between 97 and 2000/2002 because of
unicode.  

Charlotte Foust

-----Original Message-----
From: Griffiths, Richard [mailto:R.Griffiths at bury.gov.uk] 
Sent: Tuesday, April 06, 2004 12:50 AM
To: AccessD (AccessD at databaseadvisors.com)
Subject: [AccessD] A97 or A2002 


Hi Group

 

I am looking to rewrite a system (to a VB front end Access BE from Acc
FE/Be in Acc 97).  I still intend to use DAO - I am looking for advice
on whether to upgrade the Be to A2002 ( is this AXP? btw) or keep BE in
Acc 97 .

 

TIA

 

Richard

 

-- 
_______________________________________________
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