Convert Access 97 to Access 2000 from VB?

[vbSun]

Is it possible to convert an Access 97 mdb to Access 2000 mdb and vice versa from VB Code? The scenario is, I have thousands of 97 format databases in a folder which needs to be converted to 2000 format and back.

Can anyone help?

------------------------------------------
The faulty interface lies between the chair and the keyboard.

 

[bboffin]

Do you actually need to convert them?

If all you wish to do is read and/or update the data then the JET 4.0 engine will allow you to use both Access 97 and Access 2000+ databases.


Bob Boffin

 

[vbSun]

Thanks bboffin for the response. But yes I need to convert them because of various reasons (Mainly business needs, not Technical).

------------------------------------------
The faulty interface lies between the chair and the keyboard.