Lock Access During Export From SQL

• Nisha-475382

  Hall of Fame

  Points: 3535

  More actions

  November 30, 2007 at 12:27 am

  #179585

  What if I am exporting data (performing an update) to an external data source - Access (through Linked Server), how can i ensure that the Access tables arent being modified during my export process?

  Can i check if the tables are open? Can i lock the Access db for the export process duration?

  Thanks 🙂

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  December 2, 2007 at 1:21 pm

  #756311

  Does this occur regularly?

  Not sure if you can do some sort of exclusive lock in Access.

  You could export to a new file, then drop the old, rename the new.