Record locks form Access 2000 to SQL 2000

• Barry Brown-366608

  SSC Rookie

  Points: 33

  More actions

  September 13, 2006 at 4:13 am

  #90485

  I have migrated a table from Access 2000 to SQL Server 2000.

  I am updating using DAO but the message keep telling me that anmother user is accessing the record. If I point to a linked access table I do not get the error 3197.

• Jo Pattyn

  SSC-Dedicated

  Points: 32348

  More actions

  September 13, 2006 at 12:25 pm

  #660197

  Please do not cross-post

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=308126