PC Review


Reply
Thread Tools Rate Thread

Re: Link from MS SQL Server

 
 
Sylvain Lafontaine
Guest
Posts: n/a
 
      25th Apr 2010
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,
>



 
Reply With Quote
 
 
 
 
Sylvain Lafontaine
Guest
Posts: n/a
 
      25th Apr 2010
> 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
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How doI Link AS400 to SQL Server 2000 using Link Server Vince Lassiter via AccessMonster.com Microsoft Access 3 20th Oct 2004 03:56 PM
SQL Server 2000, Exchange, COM-Add in for Outlook XP; Dynamically link ACCESS xp & SQL SERVER??? Tobin Microsoft Outlook VBA Programming 1 7th Jul 2003 12:57 AM
SQL Server 2000, Exchange, COM-Add in for Outlook XP; Dynamically link ACCESS xp & SQL SERVER??? Tobin Microsoft Outlook Contacts 1 7th Jul 2003 12:57 AM
SQL Server 2000, Exchange, COM-Add in for Outlook XP; Dynamically link ACCESS xp & SQL SERVER??? Tobin Microsoft Outlook Discussion 1 7th Jul 2003 12:57 AM
SQL Server 2000, Exchange, COM-Add in for Outlook XP; Dynamically link ACCESS xp & SQL SERVER??? Tobin Microsoft Outlook 1 7th Jul 2003 12:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:16 PM.