Re: Link from MS SQL Server

Discussion in 'Microsoft Access External Data' started by Sylvain Lafontaine, Apr 25, 2010.

  1. 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,
    >
     
    Sylvain Lafontaine, Apr 25, 2010
    #1
    1. Advertisements

  2. > 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/Forums.aspx/access-externaldata/201004/1
    >
     
    Sylvain Lafontaine, Apr 25, 2010
    #2
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Gern Blandston

    link to a link of a link...

    Gern Blandston, Jul 29, 2003, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    426
    John Nurick
    Jul 29, 2003
  2. Jonathan Crawford

    Linking to an SQL Server DB using SQL Server security

    Jonathan Crawford, Nov 11, 2003, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    213
    Jonathan Crawford
    Nov 11, 2003
  3. Guest

    ODBC: link from MS SQL Server to Access 2000, change of server

    Guest, Dec 29, 2003, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    1,239
  4. Guest

    Stored Procedure in SQL Server vs MSDE 2005 SQL Server

    Guest, Jun 29, 2007, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    716
    Sylvain Lafontaine
    Jun 29, 2007
  5. Al
    Replies:
    3
    Views:
    238
    Sylvain Lafontaine
    Jan 3, 2008
Loading...

Share This Page