ACC: SQL Server Views Read-Only When Attached

ID: Q98786

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97
Microsoft SQL Server versions 4.2x, 6.0, 6.5

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:

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

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

Additional query words: sql server attach table view vbwin


Keywords          : kbusage OdbcOthr 
Version           : WINDOWS:1.0,1.1,2.0,7.0,97; winnt:4.2x,6.0,6.5
Platform          : WINDOWS winnt 
Issue type        : kbinfo

Last Reviewed: March 24, 1999