Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SimonP
Starting Member
4 Posts |
 Posted - 2004-06-04 : 07:40:25
|
| I am trying to synchronise data changes between a MS Access database and a SQL server database using DTS. I've managed to create a Data Driven Query Task to add any new records from the SQL Server source to the MS Access destination. I now want to synchronise changes made to the SQL Server records to the related records that already exist in the MS Access database. Can I do this using another Data Driven Query Task? I noticed on the DDQT that I have an option to create an update query but can I do this with the source and destination data coming from different data sources? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-04 : 14:06:36
|
| Why are you putting any data in Access?I think you need to set up a linked server and use SQL UPDATE to do this...But why?Brett8-) |
 |
|
|
SimonP
Starting Member
4 Posts |
Posted - 2004-06-07 : 04:36:10
|
| Thanks for the suggestion, Brett. I've managed to sort it out using a combination of updates, inserts and deletes, just needed to get my use of data-driven tasks right.Why am I doing this? I have an Access system running on a number of sites which have slow network connections between them. I'm using SQL server to create a centrally managed synchronisation solution. |
|
|
|
|
|
|
Updating records in Access from SQL Server Source