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)
 
Top