Replicate to MS Access via the Internet

From: dazzah (dazzahall)
Date: 10/22/04

  • Next message: al: "Ignore" 
    Date: Thu, 21 Oct 2004 21:15:08 -0700

    Can I use SQL Server’s inbuilt replication to replicate between a SQL Server
    database and a number of MS Access 97, 2000 and 2002 databases over the
    internet? I need to replicate in both directions and Jet 4.0 is installed on
    the client computers. Are there any solutions that will do this for me, or
    do I have to write a web service and the replication code myself? (The web
    server supports ASP.NET and hence I can easily write a web service in VB.NET
    or C#.)

    We have a SQL Server database on a web server and a number of clients that
    use Access to store their data locally. The clients modify their local
    database and the system administrator occasionally updates the SQL Server
    database. The clients will on a weekly basis (or as required) replicate
    their changes to the SQL Server database and also replicate the changes in
    the SQL Server database to their local databases. The clients all have
    unique data sets.

    I have found contradictory information on the newsgroups about using SQL
    Servers inbuilt replication technology. Some say that it will achieve what I
    want, others say that it won’t work. Also some suggest that replication is
    quite complex and can be flaky.

    Looking forward to your suggestions,

    Darren

  • Next message: al: "Ignore"

    Relevant Pages

    • Re: How to Replicate an SQL Server 2000 Database
      ... If i do this in Query Analyser should i have the DB closed? ... Now regarding Replication, i am brand new to this... ... And then stop and start SQL Server. ... Director of Text Mining and Database Strategy ...
      (microsoft.public.sqlserver.replication)
    • Re: Replication Suggestions
      ... Looking for a SQL Server replication book? ... >I have an application with a sql backend. ... > database on the webbox and an internal database for inter-company use. ...
      (microsoft.public.sqlserver.replication)
    • Replicate to MS Access via the Internet
      ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
      (microsoft.public.sqlserver.replication)
    • Re: How convert from Desktop to PDA
      ... Replication is used when you want to synchronize the SQL Server ... You may also do that with RDA, ... > How can I convert an Sql Server database on desktop into a Sql server CE ...
      (microsoft.public.sqlserver.ce)
    • Re: Why not Access...?
      ... It well depends how the database is used, such as the data access work load, ... When using Jet database, either VB front-end or Access front/back ... On the other hand, a database server, like SQL Server, gives you a lot more ... > 9i just can't work on these machines, and my clients are having these ...
      (microsoft.public.sqlserver.server)