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