1

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

Andre
  • 26,751
  • 7
  • 36
  • 80
Dasal Kalubowila
  • 103
  • 5
  • 22
  • You should be able to link a view just as you link a table. First, correct your two typos in the view name. – Gustav Aug 24 '20 at 08:38
  • Gustav you pedant! Was actually the developers View (shown for example), mine are further down and spelled correctly. – Dasal Kalubowila Aug 24 '20 at 12:16
  • But those I couldn't see ... – Gustav Aug 24 '20 at 12:23
  • 1
    But I do agree, attention to detail is key in our line of work! It's just sloppy to see items that are going to be used for years and years and that are difficult to edit to have typos in them. – Dasal Kalubowila Aug 24 '20 at 12:29

1 Answers1

1

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

Andre
  • 26,751
  • 7
  • 36
  • 80