Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Question Unanswered: Synchronization between Ms-Access/Sql server


    How to achieve the synchronization between Ms-Access(tables) and Sql Server (tables).

    Here i created a publisher under Sql server now i want to make use of that publisher under Ms-Access subscription.

    1. Can we create a subscription for hetrogeneous databases under Ms- Access?

    2. How to create the linked server under sql server for Ms-Access database? (possible mention the steps for secured Ms-access databases)

    If anybody known about it, Please respond this query.

    Sai Ram. P

  2. #2
    Join Date
    Feb 2003
    Auckland, NZ

    Replication and Heterogeneous Data Sources

    Microsoft® SQL Server™ 2000 offers the ability to replicate data to any heterogeneous data source that provides a 32-bit ODBC or OLE DB driver on Microsoft Windows® 2000, Microsoft Windows NT® Server 4.0, or Windows 98 operating systems. Additionally, SQL Server 2000 can receive copies of data replicated from Microsoft Access, Microsoft Exchange, Oracle, DB2 Universal, DB2/MVS, and DB2 AS400.

    Heterogeneous Subscribers
    Publishing to heterogeneous data sources allows corporations that have acquired different databases to continue providing SQL Server 2000 to individuals or offices using those databases.

    The simplest way to publish data to a heterogeneous data source is by using OLE DB or ODBC and creating a push subscription from the Publisher to the OLE DB or ODBC Subscriber.

    SQL Server 2000 supports replication between different versions of SQL Server and it supports replication to Subscribers running Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE). For more information, see Replication Between Different Versions of SQL Server and Replication with SQL Server for Windows CE.

    Heterogeneous Publishers
    SQL Server 2000 can subscribe to snapshot or transactional data replicated from Oracle, DB2, Access, and other data sources. This allows companies that are planning to deploy large databases or a data warehouse with SQL Server, or Internet and intranet applications, to gain access to various sources of data. That data can then be consolidated in SQL Server 2000 using replication, and placed into a data mart, data warehouse, or multidimensional database designed for SQL Server Analysis Services.

    To implement snapshot or transactional replication published by heterogeneous data sources to your SQL Server 2000 applications, configure SQL Server with third-party software or using applications built with SQL-DMO and the Replication Distributor Interface.
    JJ Kennedy
    Double J IT Solutions

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts