Microsoft KB Archive/208842

= ACC2000: Linked SQL Server Table Cannot Be Updated =

Article ID: 208842

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208842



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you try to make changes to a linked SQL Server table, you cannot update the table.



RESOLUTION
To work around this behavior, check that the linked table has a unique index and that the unique index does not contain a timestamp field. If the unique index does contain a timestamp field, drop the index and create a new unique index on a field other than a timestamp field.



MORE INFORMATION
A timestamp field contains a unique, binary value generated by SQL Server that is updated whenever the record is updated. Access uses the value in the timestamp field to determine whether a record has been changed before updating it.

Steps to Reproduce Behavior
  In a Microsoft SQL Server utility (such as isql/w in SQL Server 6.x or Query Analyzer in SQL Server 7.0), run the following commands:   create table TestTimestamp (field1 varchar(10), timestampfield timestamp) go   create unique index TestTimestamp_Index on TestTimestamp (field1, timestampfield)  In Microsoft Access, link the TestTimestamp table. Note that when you open the table in Datasheet view, you cannot edit or add new records.

Additional query words: prb can't be updated attach attached attaching linking link change

Keywords: kbprb kbusage KB208842

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.