Microsoft KB Archive/98786

= ACC: SQL Server Views Read-Only When Attached =

Article ID: 98786

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



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

Additional query words: sql server attach table view vbwin

Keywords: kbinfo kbusage KB98786

-

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

© Microsoft Corporation. All rights reserved.