Post reply

replication b/w Sql 2000 Db and ms-access

  • October 21, 2002 at 1:40 am

    #159180

    Hi

    We are trying continuous trasactional replication between sql 2000 db and ms-access.

    sql db is intenrrnet and ms-access db is on some other machine

    Has anybody any steps to do this..

    is this possible to be bi-directinal ?

    I ma new to replication and has never tried this..

    alos,will there be any problems regarding service account under wbich the sql server is running(do we need to change this)

    I really need help on this. Any links to articles will be helpful too..

    Thanks in advance!!

    Deepa

  • October 21, 2002 at 4:59 am

    #438983

    Transactional will work I think - been a while since I used Access as a client. I'll look, maybe someone else will remember in the interim! Merge might be a better bet if you're doing updates on both sides.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

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

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

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