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" <u59577@uwe> wrote in message news:a6fced8226ba7@uwe...
> 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,
>

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


"laymus via AccessMonster.com" <u59577@uwe> wrote in message
news:a70f8a58724ea@uwe...
> How would you like ADP project Code??
>
> Sylvain Lafontaine wrote:
>>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.
>>
>>> 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,
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...ldata/201004/1
>