Using a database created in Access 03 in Access 97

[Roby]

I created a database in 2003 at home then I went to work I found out that I
cannot open this database in Access 1997. Would there happen to be fix for
this?

Thanks in advance;

 

[Douglas J. Steele]

Very few products are designed with sufficient prescience that they can open
files created with future versions. <g>

The only fix is to take advantage of the fact that Access 2003 can save the
database in Access 97 format (look under Tools | Database Utilities)

 

[Dorian]

Well I recommend using the same version at home and at work but if you
cannot, you need to save your Access 2003 database in Access 2000 format
which 97 can read.
Look at Tools--Database Utilities--Convert Database
You can make Access 2000 the default format via Tools--Options--Advanced tab.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Douglas J. Steele]

Access 97 cannot read the Access 2000 file format.

 

[David W. Fenton]

Access 97 cannot read the Access 2000 file format.

But A2000 can save the file as A97, and the A97 version can be
opened by A2000.