CODEWITHSUNDEEP
ms-accessssmssql-viewlinked-tables
Dasal Kalubowila
Dasal Kalubowila

Reputation: 123

Can I use my Views on a SQL Sever database in MS Access?

I have Views on a SQL server database that I have painstakingly written. I am creating linked tables on my MS Access Database. I am only able to pick from tables. Is there a way to use my Views on the SQL Server within MS Access, which has all the data I need?

Views in SSMS:

enter image description here

Can only see Tables in MS Access linked Tables manager: enter image description here

Upvotes: 1

Views: 1765

Answers (1)

Andre
Andre

Reputation: 27644

Yes, you can. From Access' point of view, linked tables and views are almost identical.

Except when linking a view, you need to tell Access the primary key - for tables it it determined automatically. Without specifying the PK, the linked view is read-only.

The Linked Tables Manager in Access shows only tables/views that are already linked.

To automate the process, see here: https://stackoverflow.com/a/32316883/3820271

Upvotes: 1

Related Questions