ACC: Attached SQL Server Table Cannot Be Updated (129166)
The information in this article applies to:
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q129166
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you try to make changes to a linked (attached) 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.
Modification Type: | Major | Last Reviewed: | 5/6/2003 |
---|
Keywords: | kbprb kbusage KB129166 |
---|
|