migrating mdb(s) from Access 97 to Access 2003

[anatoly.duzhansky]

I am migrating mdb(s) from Access 97 to Access 2003.
I have never used MS Access before. (I'm PowerBuider developer.)
I understand that I have to install MS Access first (of course!) then
MS Access 03 -> Tools -> Convert database ->Access 2002-2003 file
format.

What else do I need to know and what else do I need to check?
The front end that is working with Access databases developed with
VB6.

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

Access 97 used JET 3. Access 2000, 2002, and 2003 all use the newer JET 4.

You will need to test you front end completely to see if it can the handle
new Jet format.


You actually do not need to install Access 2003 to convert the to Jet 4. You
can use the JetComp4 utility from Microsoft to do it on an 2000/XP OS.

Make sure you keep lots of backups!

I am migrating mdb(s) from Access 97 to Access 2003.
I have never used MS Access before. (I'm PowerBuider developer.)
I understand that I have to install MS Access first (of course!) then
MS Access 03 -> Tools -> Convert database ->Access 2002-2003 file
format.

What else do I need to know and what else do I need to check?
The front end that is working with Access databases developed with
VB6.

--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com