Should I convert db from Access 97 to Access 2000 
Author Message
 Should I convert db from Access 97 to Access 2000

Have an application reading from an Access 97 database using ADO
2.1.1.3711.11 (GA) and Ms Jet 4.0 OLEDB.  The 2.1.1.3711.11 manifest
mentions that Jet 4.0 databases support Unicode and that when reading
a 3.5 database, Jet converts the 3.5 ANSI string data to Unicode.  It
suggests this is a performance hit and recommends that 3.5 databases
be converted to 4.0.  The MDAC 2.5 manifest then seems to contradict
this by saying the information is incorrect.

Should I upgrade my 3.5 (Access 97) database to 4.0 (Access 2000) or
not?

If so, how can I do that.  I don't have a copy of Access 2000, but I
suppose I could acquire it if necessary.  Is there another way?

Thanks

Gary Cramblitt

Remove "--" from my address to send me e-mail.



Sat, 18 Jan 2003 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Convert Access 97 db to Access 2000 db in VB6

2. Converting Access 97 DB to 2000 using VB

3. opening access 97 db after convert/importing to 2000

4. Converting Access 2.0 DB to Access 97 DB in VB code

5. Using VBA to Convert Access 2000 database to Access 97

6. Access 2000 converted to Access 97 report query data type errors

7. Converting Access 97 to Access 2000 via VBA

8. Converting Access 2000 to Access 97

9. Convert Access 97 - Access 2000

10. Converting from Access 97 to Access 2000

11. Access 97 upgrade to Access 2000 or Access 2002

12. Converting Modules from Access 97 to 2000

 

 
Powered by phpBB® Forum Software