RE: SQL replication to Access Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 09:21:27 GMT

Hi John,

Thanks for your posting!

>From you discriptions, I understood that you would like to replicate Access
mdb file with a SQL Server via Internet. Have I understood you? If there is
anything I misunderstood, please feel free to let me know.

Based on my scope, you could replicate between Access database via Internet
but could not replicate between Access and SQL Server. You will have to
change Access database to MSDE first. Here are some documents on how to
make a replication between Access databases via Internet.

Database Replication in Microsoft Jet 4.0
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/htm
l/dbrepjet.asp

Internet Synchronization with the Microsoft Jet Database Engine: A
Technical Overview
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/htm
l/intrjet4.asp

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
 

Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Relevant Pages

  • 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)
  • 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
    ... My understanding is that this allows you to replicate an Access Database to ... another Access Database over the internet. ... Looking for a book on SQL Server replication? ...
    (microsoft.public.sqlserver.replication)
  • Re: Access Database transactional replicated into SQL Server 2000
    ... Access database if you create an odbc datasource subscriber. ... You could create a merge publication on your SQL Server and create the ... This will replicate the changes in the ...
    (microsoft.public.sqlserver.replication)
  • Replication over the internet
    ... Can I replicate from one sql server to another over the internet? ... Regards, ...
    (microsoft.public.sqlserver.replication)