Folks...
I have a client that is running MS Access 2002 for 10 people out in the field. The client wants to be able to replicate the data from MS Access 2002 to the SQL Server 2000. In addition, the client wants to have each field person only work on their own s
pecific data set during the replication. So the entire SQL Server database does not get replicated to the MS Access database. A good thing.
What would be a best practice approach to accomplish setting up the MS Access database and setting up the 'filters' only to pull the data that will be specifically worked on by the client.
I did some looking on the MS website and some other links...but of course the data is always fragemented.
Mephisto822
The easiest way of setting this up is using merge replication and dynamic
filters. For the dynamic filter there are options of HOST_NAME() and
SUSER_SNAME() functions and UDFs based on them, but I would suggest using
the -HOSTNAME agent parameter to easily partition the data according to
subscriber. This also gives you the option of using a business-related
partitioning value, rather than the computername. HTH,
Paul Ibison
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment