Access 97 - Access 2000 use compatibility

[Bill Wright]

At our site in Dallas we have developed some MS Access 97
applications that reside on a server. Many individuals
run this application to enter data into the data base and
then to run reports. At an offshore location that
facility has MS Office 2000 installed on all of their
PC's. Every hour we port over the network a copy of each
other's data files so they can locally be stored and run
against for reports. Question: Since the application
was written in MS Access 97, can users overseas use their
Access 2000 to read and write data, and creat reports
using their MS Access 2000 ?

 

[Allen Browne]

Split the application into two mdb files: Tools | Database Utilities |
Splitter.

The tables end up in in one (the back end), and other objects in the other
(queries, forms, reports, code). The front end links to the back end tables:
File | Get External | Link.

Now you can convert the front end to Access 2000, so those users can have
their own version. It can still link to the A97 tables. This avoids the
whole issue of opening the A97 file with A2000 and being unable to change
anything.