Upgrading 97 to 2002 with XP

[Guest]

Hello,

Our company is in the process of upgrading to XP. We have a couple databases that we use that were made in 97. I tried to convert the database to 2000 and 2002 and keep getting errors and modules that were showing up with errors. Is there a way to upgrade without so many problems...I have also tried opening the database in 97 and compling the modules and the code is written wrong because I get a compile error: Sub or Function not defined....

Any suggestions?
Thanks

 

[Douglas J. Steele]

It won't convert if it can't be compiled. You're going to have to fix the
problems in Access 97 so that it compiles cleanly. Once that's done, the
conversion should be relatively painless.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hello,

Our company is in the process of upgrading to XP. We have a couple

databases that we use that were made in 97. I tried to convert the database
to 2000 and 2002 and keep getting errors and modules that were showing up
with errors. Is there a way to upgrade without so many problems...I have
also tried opening the database in 97 and compling the modules and the code
is written wrong because I get a compile error: Sub or Function not
defined....