Post reply

Updating MS Access database through S2K trigger

  • November 2, 2007 at 3:24 pm

    #98677

    Hello,

    I would like to know if it is possible to update a Microsoft Access database by means of a trigger in a SQL Server database. If it is, kindly refer me to some place where I can learn how this is done.

    Thanks,

    Karim

  • November 3, 2007 at 8:19 pm

    #748032

    Hi,

    Try this

    1.) Create a linked server to the MS Access db

    2.) Create the DDL trigger and using the created linked server you can update the MS access db.

    I hope this might help you

    Regards..Vidhya Sagar
    SQL-Articles

  • November 4, 2007 at 4:54 am

    #748046

    I would recommend that you queue your updates in the trigger and then have some timed event read the queued updates and apply them to the Access DB. You don't want your SQL Server queries held up due to interacting with the Access DB.

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

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