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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Offline Replication, Updates, etc.

Author  Topic 

gogo7188
Starting Member

12 Posts

Posted - 2003-05-22 : 09:14:32
We have a small app that is based on, gasp, Access with a SQL Server back-end. It is simply a program that has a few forms with pavement information in them. We have some users who are going to go out in the field and make changes to the pavement information (i.e. update some streets, add new pavement grading sections, etc.)

Question is two-fold. What type of replication should I setup in SQL Server so that they can pull down the data to their laptop before going out into the field and be able to make changes then post them (update) when they get back in the office?

Is there a better way to do this than Access? Should I write some ASP, etc.?

Any thoughts or help here would be greatly appreciated. Thanks, Chad

samrat
Yak Posting Veteran

94 Posts

Posted - 2003-05-26 : 06:09:15
Merge replication best suits your scenario. BOL has lot of articles on "How To...". If you need further assistance in setting up let us know.

Regards,

Samrat
Go to Top of Page
   

- Advertisement -