How to setup replication between access to SQL Server , MSDE instead of Access

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Karen Middleton (karenmiddleol_at_yahoo.com)
Date: 10/14/04 

Date: 14 Oct 2004 05:50:28 -0700

Hello All

We have a computer based application running on trucks and they
capture the transaction into a Access database we need to collect the
data from multiple trucks into a SQL Server database centrally.

Can somebody please explain whether Access can replicate to SQL Server
with Access as publisher and SQL Server as the subscriber. Also, I am
wondering is it worthwhile to replace Access by MSDE since MSDE is
free I would appreciate your feedback on this count.

Also, any books, web sites, white papers and how to setup a
replication from Access to SQL Server. Also, can somebody please
explain how the replication works from Access to SQL Server and is it
lot of coding to get this working and what kind of replication is it
full table or delta replication.

Also, some of our trucks will be in far off places is there a nice way
in which Access can be made to replicate from these remote sites to
the central site what kind of comms do we need.

Many thanks in advance for your inputs

Thanks
Karen

Relevant Pages

  • Re: Access 2000 to SQL Server 2000 Standard
    ... AFAIK you can't replicate to an access database over the internet. ... Looking for a book on SQL Server replication? ... The merge replication stuff in> BOL doesn't address the internet delivery in enought detail for a beginner> like me. ...
    (microsoft.public.sqlserver.replication)
  • Re: Access 2000 to SQL Server 2000 Standard
    ... Presumably they could keep their Access database, ... > AFAIK you can't replicate to an access database over the internet. ... > Looking for a book on SQL Server replication? ...
    (microsoft.public.sqlserver.replication)
  • How to setup replication between access to SQL Server , MSDE instead of Access
    ... We have a computer based application running on trucks and they ... capture the transaction into a Access database we need to collect the ... Can somebody please explain whether Access can replicate to SQL Server ... replication from Access to SQL Server. ...
    (microsoft.public.sqlserver.replication)
  • How to setup replication between access to SQL Server , MSDE instead of Access
    ... We have a computer based application running on trucks and they ... capture the transaction into a Access database we need to collect the ... Can somebody please explain whether Access can replicate to SQL Server ... replication from Access to SQL Server. ...
    (microsoft.public.sqlserver.msde)
  • RE: How to setup replication between access to SQL Server , MSDE inste
    ... And the Access DBs should be subscribers and the SQL server would be the ... > data from multiple trucks into a SQL Server database centrally. ... > replication from Access to SQL Server. ...
    (microsoft.public.access.replication)