Converting MS Access 97 to MS Access 2000

[edushkushot]

Hi there,

I successfully converted an Access 97 database to Access 2000. But certain forms and functions are not working correctly. I'm sure there are differences in VBA across both Access versions.

Is there a tool to convert Access 97 VBA to Access 2000 VBA compatible code? There is a lot of code and forms, and I would hate to recode this whole project as the previous contracter used Access 97.

Thanks in advance.

G

 

[PHV]

The main difference is DAO (97) vs ADO (2k) default container for recordset.
You have to reference an ActiveX Data Object and to qualify all your recordset definition in all your procedures/functions.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244