Upgrading to Office 2003

[Aidan Tobin]

Hi,

I have to upgrade a number of databases from Access 2.0, Access 97 and
Access 2000 to work in Office 2003. These databases contain a number
of Forms coded with VBA as well as a number of Queries/Macros.

The Microsoft web site says that Office 2003 will open databases
created in these versions.

However i have in the past upgraded databases from access 2.0 to 97
and have encountered problems with the VBA code, and i have used the
built in tools for some simple databases to upgrade to 2000 from 97
but these ones are more complex so i may not have encountered all the
problems, and i have never upgraded to Office 2003

Do You know of any issues with upgrading from these version's to
Office 2003

Thanks in Advance

Aidan Tobin

 

[Pieter Wijnen]

Just done it... ('97 -> 2003)
The only real problem was that I had to relink a Library Database (mde) &
recreate my security database (.mdw) & set up user (rather Group)
permissions anew (coded that using PrivDBEngine) . If your converted 2.0 app
still contain obsolete domenuitem calls and/or Dynaset references o.a - I
would think you'd have to change those first...

HTH

Pieter