Running different version of Access

[Guest]

Hi,

We have a database which was created using Access 2000. We have been
running this database for a while as a FE/BE. Recently some of our computers
have been upgraded and are now running Access 2003.

Will this cause problems running the same database with different versions
of Access?

Many thanks

Ian

 

[Douglas J Steele]

It shouldn't. The default file format for Access 2003 (and Access 2002, for
that matter) is the Access 2000 format.

 

[Allen Browne]

It should not cause a problem.

A2003 defaults to the Access 2000 file format, so that should not be an
issue. Naturally the back end cannot be A2002 format if A2000 is to use it.

The more important issue is that the binary is different in each version of
Access. I suggest, therefore, that you edit and maintain the database using
Access 2000, so the A2003 binary never muddles the front end. This will also
allow you to release an MDE to give to each workstation. (A2003 cannot
generate an MDE from an A2000 format file.) The MDE cannot decompile, so
everything should be sweet on all workstations.

If you ever do edit the file in A2003, be sure to decompile before switching
back to A2000.