Subject | synchronize data database tables |
---|---|
Author | petesouthwest |
Post date | 2004-08-26T10:39:34Z |
Hi
Is there an easy way to allow several users to synchronize the data
in database tables?
My app will be used on users' home machines as well as a LAN at work
and I need to be able to allow them to easly 'transfer' the work ie
data, they have done back and forth. It needs to be an automatic
routine that allows them to select their file and then updates only
the records they have modeified or added.
In the past I have done this by allowing them to export the data to
a CSV file of their choice and then import it back. I did this using
SMI components that were reasonable priced. However, this involved
mapping columns which seems long and error prone for a lot of tables
with a lot of fields.
Is there a better, easier way of doing it?
Thanks
Pete
Is there an easy way to allow several users to synchronize the data
in database tables?
My app will be used on users' home machines as well as a LAN at work
and I need to be able to allow them to easly 'transfer' the work ie
data, they have done back and forth. It needs to be an automatic
routine that allows them to select their file and then updates only
the records they have modeified or added.
In the past I have done this by allowing them to export the data to
a CSV file of their choice and then import it back. I did this using
SMI components that were reasonable priced. However, this involved
mapping columns which seems long and error prone for a lot of tables
with a lot of fields.
Is there a better, easier way of doing it?
Thanks
Pete