Converting Access 97 To Access XP

[JasGrand]

Hello, I have an Access 97 database that needs to be converted to Access XP. I keep getting conversion errors and I was wondering if there was a program out there that could tell me where I'm getting the error during conversion (or if there is a better conversion program then the one built in Access XP).

Thanks,


Jason Grandmaison

 

[ReAn]

might wanna try converting it to a2000 then to axp

 

[ghudson]

Does your code compile? You must compile your code before you attempt to convert. Also, are you missing any references?

 

[Pat Hartman]

Open the db in A97 and compile it. Fix all compile errors. If you have DAO code, change all the dim code for the DAO objects so that it is qualified.

Dim db As DAO.Database
Dim qdf As DAO.Querydef
Dim rs As DAO.Recordset
etc.

A2K and newer versions are more picky about "bad" code.