Migrate Access 2.0 to Access 2002

[MarcusAntonius]

I need to update a database from Access 2.0 to 2002; does anyone have any hints and tips? Is there a structured methodology to doing this?

At least using the convert feature results in Access crashing (Access has encountered a problem and needs to close).

 

[llkhoutx]

Try recompiling, correcting errors as you encounter them. If you use any DAO, be sure to add the Microsoft DAO 3.6 Object Library reference and predicate each database and recordset definition with "DAO," e.g.

dim db as dao.database
dim rs as dao.recordset

 

[MarcusAntonius]

How do I recompile it?

At the moment, it seems the best method is to export all the tables/queries/forms and then import them into 2002 and go from there.