Access link to a view not a table
-
I've been using Access for all my queries against a SQL Server database by using the link table connection. I've created a view on the database and I would like to link to the view.
Is that possible?
How?
-
Access inherently "grabs" ALL tables and views that the user has SELECT permission and displays them ALL under the "TABLE" guise....
Good Hunting!AJ Ahrens
webmaster@kritter.net -
This is where naming conventions and prefixes come in handy, I can instantly differentiate between tables and views when I'm managing connections.
It's also advantageous to have your objects owned by DBO so that they sort better in the display.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply