D
Dave Holmes
I am using Access 2000.
I am developing an application which maintains supplemental
information to an existing database. Briefly, it connects via an ODBC
connection to a demographics record in the other db. The "foreign"
data is read-only in my app and cannot be altered in any way. Local
tables contain the additional data.
I need to track changes to the demographic data in the "foreign"
database on a daily basis. Is there a way to do this other than making
a daily local copy of the table and comparing record-by-record,
field-by-field then following day?
Thanks,
Dave Holmes
I am developing an application which maintains supplemental
information to an existing database. Briefly, it connects via an ODBC
connection to a demographics record in the other db. The "foreign"
data is read-only in my app and cannot be altered in any way. Local
tables contain the additional data.
I need to track changes to the demographic data in the "foreign"
database on a daily basis. Is there a way to do this other than making
a daily local copy of the table and comparing record-by-record,
field-by-field then following day?
Thanks,
Dave Holmes