[Welshhobo]

In my school the were using VB6 to program a game in. VB6 only likes to data link with access 1997.
If a version of access is set to 1997, the only way to edit the database (except for putting new records in) is to use the 1997 version of access.
My school uses access 2003, this means we have to make our database in 2003 then use the converter built into 2003 to get our 1997 version of our database so it is compatible with VB6.
I however only have 2007 at home, so i was wondering if it is possible to convert my 2003 database to 1997 format without having to get a copy of 2003 just to use the built-in converter.

Thanks in advance

[Advertisements]

To convert an Access 2007 database to a file format that is compatible with Access 97 or earlier, you must first use Access 2007 to convert the database to the Access 2000 file format or the Access 2002 - 2003 file format. Then you use an earlier version of Access to convert the database to the format that you want. For example, by using the Convert Database command in Access 2003, you can convert an Access 2000 database or an Access 2002 - 2003 database to the Access 97 file format.

You should also read the rest of the page that the quote comes from as there are caveats. But the bottom line is, you can't do it from 2007.
http://office.micros...2308221033.aspx

[Neil Jones]

To convert an Access 2007 database to a file format that is compatible with Access 97 or earlier, you must first use Access 2007 to convert the database to the Access 2000 file format or the Access 2002 - 2003 file format. Then you use an earlier version of Access to convert the database to the format that you want. For example, by using the Convert Database command in Access 2003, you can convert an Access 2000 database or an Access 2002 - 2003 database to the Access 97 file format.

You should also read the rest of the page that the quote comes from as there are caveats. But the bottom line is, you can't do it from 2007.
http://office.micros...2308221033.aspx

[Welshhobo]

Bah, so ill just have to get Access 2003 ?

Can you have both 2003 and 2007 on a computer simultaneously?

[Neil Jones]

Yes.