Replication between SQL Server and MS Access

Hello,



I want to share / synchronize / replicate data using Microsoft SQL Server and Microsoft Access.



Description of problem/situation:

I have a SQL Server located in our head quarters and several others in other plants. Everybody needs to synchronize with the main db and every user must be able to update/add/change data in this db. I was thinking to use ‘linked tables’ to establish the link but than I heard about some users who would like to travel with their laptop. That’s why I would like to set up a replication.

I started reading but after 5 days I still haven’t find the right way… I’m getting desperate!



This is what I tried:

• configure publishing, subscribers and distribution (no real problems)
• create and manage publications using ‘merge publication’ and ‘heterogeneous data sources’ (no problems).
• create new subscription: I really don’t know how to point to the Access database (installed on client. I also tried to link with an Access db on the server but I also get errors). I already tried several set ups but still can’t get this thing working. I read somewhere on the internet that I need to configure a linked or remote server.

I also tried a variant using MSDE as subscriber (installed on each client) and than using MS Access to update/add/change the data.



And what will happen with the field ‘GUID’ when I add a row using MS Access?



Any help would be appreciated!



Bruno

I have exactly the same scenario.

I'm writing an App that needs to store the data on SQL but have the ability to work offline by laptop users then sync upon reconnection to their network.

I'd like to use Access on the Client side so that I don't have to install MSDE but can't seem to find out how this is done!!

Please help preferably in Mr Men language!!

I am working on the same issue. Have you found a solution to this?