Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    4

    Unanswered: Connect to Microsoft Access via Stored Procedure

    Hi,

    I'm new to SQL server, still in the beginning stage of learning SQL Server. I'm here would like know, besides using the Connectivity from the DTS Designer to connect to different databases, is it possible to connect the database, i.e: Access via stored procedure? and how? Pls advise...

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You could use a pass-through query to execute an SQL statement that runs your sproc, but I'm not sure how you would handle any result set that is returned.
    Regardless, I am moving this thread to the Access forum, where you may find people who have done this before.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jul 2003
    Location
    Romania
    Posts
    8

    One way to Connet to Microsoft Access is

    ...with linked server
    You can do that with system stored procedure sp_addlinkedserver

    i.e (in the case on connection to access)

    sp_addlinkedserver 'srv_link', 'Access 97', 'Microsoft.Jet.OLEDB.4.0',
    'the_full_path_to_my_db.mdb'

    you have to change the last line.

    and to access table my_table from the Access Database
    you must use the 4 part name:

    select * from srv_link...my_table

    Hope that helps you.

    Best regards,
    Adriana

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •