I use Access when I don’t have dedicated admin tools for editing data, frequently the case for infrequently changed data in smaller projects. Linked tables work reasonably well, just have to create a DSN first.
Except…it doesn’t seem to work (at least obviously) for synonyms. Here’s one I created (viewing as sysadmin):
And the view when linking from Access, also with syadmin credentials:
In this case I just wanted to peek at a row just inserted. Not that I couldn’t run the select, but was (or would have been) convenient to do so, as often I wanted to update the row so it would re-process without having to run through the entire process again.
I get that it’s not always a table/view, would be strange to link to a proc – but isn’t that what metadata is for?
Why synonyms? I’ve a huge fan of two part syntax. Not one part, not three, not four. Make it all look local, when it’s time to move the db life is good, just update all the synonyms and move on, no code changes.