How would I link a sql view into my database? I have found code to do a table, but no code to do a view?
How would I link a sql view into my database? I have found code to do a table, but no code to do a view?
Go to Heaven for the climate, Hell for the company.
~~Mark Twain
Write a query and use that? A query can span multiple tables.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
You can link to views in SQL Server just the same way you do for tables, if that is your question. I assume what you are asking about is ODBC linking from Access to SQL Server. If that is not correct, please provide more details on what you need and the environment in which you are working.
Last edited by GP George; 04-26-2014 at 08:49 PM. Reason: syntax
"We're all in this together."
-Red Green