SQL Server 6.5 - Error 3197

• HomerJ

  SSC Rookie

  Points: 46

  More actions

  July 7, 2003 at 9:27 am

  #83785

  Hi all:

  I have a SQL Server 6.5 back end with a VB6 app on the front connecting via DAO.

  The system has been running flawlessly for 2 years but a couple weeks ago I had to increase the size of a varchar field and to do that I had to create a temp table, copy the data over, drop the original and rename the new table.

  Since doing that I have been getting error # 3197 when accessing the table. It complains that the record is locked by another user even though it isn't.

  Any thoughts on how to rectify this situation?

  TIA

• July 10, 2003 at 8:00 am

  This was removed by the editor as SPAM

• paul_richardson

  SSCarpal Tunnel

  Points: 4594

  More actions

  July 10, 2003 at 9:29 am

  #464907

  hi homerJ

  have you tried to DBCC the database ? (or just the table) This might clear the problem.

  Paul

• HomerJ

  SSC Rookie

  Points: 46

  More actions

  July 10, 2003 at 11:19 am

  #464938

  I figured it out. I added a timestamp field to the table and then recreated the indices. Works fine now. Hope this helps someone else.