Post reply

Acess (mdb) file as Publisher

  • May 6, 2002 at 11:30 am

    #79103

    Hello,

    Can I use a Access file as a publisher (DBASCMfg.mdb) on a remote server...mapped to a logical drive on SQL Server and then use transactional replication to duplicate the tables onto a SQL server database. Please let me know how. After going thru the book I can only see SQL server DBs using wizards on Enterprise Manager.

    Thanks

    Raghu

    Raghu


    Raghu

  • May 6, 2002 at 7:59 pm

    #428543

    I have never seen this work and do not believe you can do it directly. You might could setup a SQL server to act as mediate by pulling the data periodically makeing only chanes and publishing back out.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • May 7, 2002 at 6:10 am

    #428582

    I know that I have gotten merge replication between SQL and Access to work, so even if you can't get transactional to work you could go with this. MDB was local during my test.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply