Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Linked SQL Server Table Cannot Be Updated

ACC2000: Linked SQL Server Table Cannot Be Updated

View products that this article applies to.

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).

↑ Back to the top

Symptoms

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

↑ Back to the top

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.

↑ Back to the top

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

1.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)
2.In Microsoft Access, link the TestTimestamp table. Note that when you open the table in Datasheet view, you cannot edit or add new records.

↑ Back to the top

Keywords: KB208842, kbusage, kbprb

↑ Back to the top

Article Info
Article ID : 208842
Revision : 2
Created on : 6/24/2004
Published on : 6/24/2004
Exists online : False
Views : 327