ACC: SQL Server Views Read-Only When Attached (98786)


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
This article was previously published under Q98786

SUMMARY

Advanced: Requires expert coding, interoperability, and multiuser skills.

Microsoft SQL Server supports updatable views. Microsoft Access can only link (attach) these views as read-only because SQL Server views do not have indexes. Microsoft Access requires a unique index on the linked object for update/delete/insert capability.

For more information about Microsoft Access and updating linked SQL Server tables, please see the following articles in the Microsoft Knowledge Base:

90100 ACC1X: Remote ODBC Tables Are Read-Only Without a Unique Index

112131 ACC: Creating Virtual Indexes with SQL Data-definition Queries

Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbinfo kbusage KB98786
©2002 Microsoft Corporation. All rights reserved.