Link from MS SQL Server

[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,

 

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

 

[laymus via AccessMonster.com]

How would you like ADP project Code??

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]

How would you like ADP project Code??

Huh?

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