Access 2000 backwards compatible.

[liz]

Hope you can help.

If a shared database has been created in Access 97 and it
is converted to 2000 and changes saved will both 97 & 2000
users be able to use it without problems?

Thanks

Liz

 

[Douglas J. Steele]

Split your database into a front-end (containing the queries, forms,
reports, macros and modules) and a back-end (containing the tables). Leave
the back-end in Access 97. Keep the Access 97 front-end for those who still
have Access 97, and convert a copy of the front-end for Access 2000 for
those who have Access 2000.

 

[Larry Daugherty]

People have responded to your post with the assumption that only 1
system is used to make DESIGN changes. For the Access 97 folks to be able
to use the system the changes must be made using Access 97 or they can be
made in a system using Access 2000 and then saving " ... as prior version".
I.e. saving as an Access 97 mdb.

However, if the database is saved as Access 97, users of both versions can
use it and change the data.

hth

 

[Arvin Meyer]

The data must stay in A97 if both versions are to use it. The front-end
(code, queries, forms, and reports) can be in either version, running on
workstations, but development really should take place in the 97 version,
and converted for the A2000 users. Changes made in the A2000 front-end and
converted back are usually not quite as efficiently compacted.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access