=?Utf-8?B?QmVleWVu?= wrote in
:

Good Day Mr. Fenton,

What I mean by synchronizes; is having the database from Access 97
synchronize to a converted Access 2003.

Synchronize *what*? Data? Forms? Reports?

Perhaps it is referred to as
something else. You see after the Access 97 database was
converted to Access 2003, there remain quite a few users that
continued entering data in Access 97 database. It will be at least
another month or so before the users of Access 97 will have the
Access 2003 installed. Although, the queries are being run from
the Access 2003 database, there is a need for data from Access 97
to be included. So I was hoping there would be a way to match up
the data from Access 97 to Access 2003.

The obvious solution, seems to me, is to split the app (I'd assumed
it was already split?), and create a Jet 3.5 back end (i.e., A97's
format), then link all the front ends to that. This means you'd be
editing one data file whether the user was in A2K3 or A97, and you
then would have no need to synch two separate MDBs.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/