Converting access 97 to access 2002 (1 Viewer)

[Mcgrco]

Does anyone know if its possible to convert a 97 database to access 2002.

I have 100s of small databases and what i would like to do is place them all in a folder, loop through each one and convert it to a 2002, with a new name.

Thanks in advance

 

[Pat Hartman]

You can do it but you'll have trouble if the old databases are not compiled or if they have DAO code in them.

 

[Mcgrco]

Thanks for your reply Pat,

I do have problems with DAO databases due to the reference not been set. I tryed to add the reference in code before it was converted but I cant work out how to do it. The database only have small amounts of simple code, but there are 100s needing converting, hence the need for automation. Any ideas on how I could get around the DAO reference issue.

What Im trying to do is throw all the db's in a folder and loop through them 1 by 1 converting them on the way. The loop falls over as soon as it hits a DAO piece of code. Even if i could get the loop to ignore these databases it would be fine.

Any thoughts