Link from MS SQL Server

L

laymus

Is it possible to link query from MS SQL Server?

It will be nice to link a query from MS SQL Server instead of link the table.

Your information is great appreicated,
 
S

Sylvain Lafontaine

You can link to a View like if it was a table. See
http://support.microsoft.com/kb/q209123/ if you want to have them updatable
(read/write).

If you want to link to a Stored Procedure, you will have to either use a
Passthrough query or switch to an ADP project.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top