Need some important help to get added/modified rows from Access tables. (1 Viewer)

Hi,
I have a 3rd party desktop application to manage inventory. The data will be stored in local MS Access database. I want to sync any changes (insert, update or delete) made to this database to remote MS Sql server immediately or in batches using a scheduler.

Is there any method to know the changed rows in an MS Access table after x time. I mean I want to get all the rows in an Access table that have been added or modified after a particular date and time (say "05-23-2007 10:15:00") without using a user defined date time column in that table.

If i can do the above operation, i will write queries to get the added or modified rows and update remote server in batches.

Thanks and Best Regards,
Anz

As Access does not have internal DateTimeStamps you WILL have to add them to your Access tables and carry that information over to the SQL server.