sending records to main database.

[mon]

Hi All, still working on my little project.
I have a small database for every employee to fill their
activities in locally on their laptops. There are three
tables involved and I would like the new addded records to
be emailed to the office to be incorporated in the main
database. What I am doing at the moment is running a
macro which first copies the not yet uploaded records from
the three tables into a new database, then the records are
updated as having been uploaded. (I have a true/false
field called "uploaded"). Just wondering if there is an
Better way.
Thanks
Mon

 

[John Vinson]

Hi All, still working on my little project.
I have a small database for every employee to fill their
activities in locally on their laptops. There are three
tables involved and I would like the new addded records to
be emailed to the office to be incorporated in the main
database. What I am doing at the moment is running a
macro which first copies the not yet uploaded records from
the three tables into a new database, then the records are
updated as having been uploaded. (I have a true/false
field called "uploaded"). Just wondering if there is an
Better way.
Thanks
Mon

It's not all that simple to implement, but Replication is designed
precisely for this situation. There's a good FAQ about replication at
MichKa's website http://www.trigeminal.com.