Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Connect to OLEDB..?

Discussion in 'Information Technology' started by Kent Johnson, Nov 3, 2005.

Tags:
  1. Kent Johnson

    Kent Johnson
    Expand Collapse
    Guest

    Hi all,

    I usually link tables from a datasource via ODBC but now I have a SAS OLEDB
    datasource.
    How can I connect to a OLEDB-datasource from Access?

    /Kent J.
     
  2. Loading...

    Similar Threads Forum Date
    Connected Blogs Oct 17, 2015
    connection! Blogs Oct 17, 2015
    Still No Connection Blogs Oct 17, 2015
    connection Blogs Oct 16, 2015
    Ways to Connect to The Guru - Suggestions? Questions and Answers May 27, 2014

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    You can't as a linked table, but you can open an ADO recordset in VBA code,
    assuming you know the appropriate connection string to use to connect.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Kent Johnson" <08.6044303@telia.com> wrote in message
    news:uC9af.149809$dP1.507648@newsc.telia.net...
    > Hi all,
    >
    > I usually link tables from a datasource via ODBC but now I have a SAS

    OLEDB
    > datasource.
    > How can I connect to a OLEDB-datasource from Access?
    >
    > /Kent J.
    >
    >
    >
     
  4. Kent Johnson

    Kent Johnson
    Expand Collapse
    Guest

    OK!
    How can I use ADO to connect to a OLEDB datasource?

    /Kent J.

    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:eWQWTN$3FHA.3400@tk2msftngp13.phx.gbl...
    > You can't as a linked table, but you can open an ADO recordset in VBA

    code,
    > assuming you know the appropriate connection string to use to connect.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Kent Johnson" <08.6044303@telia.com> wrote in message
    > news:uC9af.149809$dP1.507648@newsc.telia.net...
    > > Hi all,
    > >
    > > I usually link tables from a datasource via ODBC but now I have a SAS

    > OLEDB
    > > datasource.
    > > How can I connect to a OLEDB-datasource from Access?
    > >
    > > /Kent J.
    > >
    > >
    > >

    >
    >
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    See, for example,
    http://msdn.microsoft.com/library/en-us/dnado/html/workshp2.asp

    Doing a Google search on ADO should also result in thousands of hits.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)



    "Kent Johnson" <08.6044303@telia.com> wrote in message
    news:esaaf.149815$dP1.507609@newsc.telia.net...
    > OK!
    > How can I use ADO to connect to a OLEDB datasource?
    >
    > /Kent J.
    >
    > "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > news:eWQWTN$3FHA.3400@tk2msftngp13.phx.gbl...
    >> You can't as a linked table, but you can open an ADO recordset in VBA

    > code,
    >> assuming you know the appropriate connection string to use to connect.
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>
    >>
    >> "Kent Johnson" <08.6044303@telia.com> wrote in message
    >> news:uC9af.149809$dP1.507648@newsc.telia.net...
    >> > Hi all,
    >> >
    >> > I usually link tables from a datasource via ODBC but now I have a SAS

    >> OLEDB
    >> > datasource.
    >> > How can I connect to a OLEDB-datasource from Access?
    >> >
    >> > /Kent J.
    >> >
    >> >
    >> >

    >>
    >>

    >
    >
     

Share This Page