ACC: SQL Server Views Read-Only When Attached

• 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