Welcome to SPN

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

Sign Up Now!

Re: Determining ODBC

Discussion in 'Information Technology' started by wnfisba, Jul 28, 2006.

  1. wnfisba

    wnfisba
    Expand Collapse
    Guest

    That was simple. Thanks a ton!

    "'69 Camaro" wrote:

    > Hi.
    >
    > > Is there anyway I can determine what ODBC the Access Database is using to
    > > access the SQL Server Tables from within the Access Dtabase Application???

    >
    > Select the Tools -> Options... menu to open the Options dialog window.
    > Select the "View" tab and ensure that the Show "System objects" check box is
    > checked. Select the "OK" button to close the window.
    >
    > Select the Tables tab in the Database Window and scroll until you see the
    > MSysObjects table. Open this table and find the name of the linked table
    > you want. In the Connect column for that record you'll see the connection
    > string for that table, which starts with "DSN=". Whatever is right after
    > that but before the semicolon is the name of the DSN used for that link.
    >
    > HTH.
    > Gunny
    >
    > See http://www.QBuilt.com for all your database needs.
    > See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    > http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    > info.
    >
    >
    > "wnfisba" <wnfisba@discussions.microsoft.com> wrote in message
    > news:CCC8ACD0-EA7F-4152-8175-849FD7EBCDE5@microsoft.com...
    > >I have an Access Database application that actually ODBCs to a SQL Server
    > > Database.
    > >
    > > Is there anyway I can determine what ODBC the Access Database is using to
    > > access the SQL Server Tables from within the Access Dtabase Application???
    > >
    > > Thanks in advance for your help...

    >
    >
    >
     
  2. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    You're welcome! Glad it helped.

    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "wnfisba" <wnfisba@discussions.microsoft.com> wrote in message
    news:BC56CCD1-B501-4A3B-A414-D154CFB61470@microsoft.com...
    > That was simple. Thanks a ton!
    >
    > "'69 Camaro" wrote:
    >
    >> Hi.
    >>
    >> > Is there anyway I can determine what ODBC the Access Database is using
    >> > to
    >> > access the SQL Server Tables from within the Access Dtabase
    >> > Application???

    >>
    >> Select the Tools -> Options... menu to open the Options dialog window.
    >> Select the "View" tab and ensure that the Show "System objects" check box
    >> is
    >> checked. Select the "OK" button to close the window.
    >>
    >> Select the Tables tab in the Database Window and scroll until you see the
    >> MSysObjects table. Open this table and find the name of the linked table
    >> you want. In the Connect column for that record you'll see the
    >> connection
    >> string for that table, which starts with "DSN=". Whatever is right after
    >> that but before the semicolon is the name of the DSN used for that link.
    >>
    >> HTH.
    >> Gunny
    >>
    >> See http://www.QBuilt.com for all your database needs.
    >> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    >> http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    >> info.
    >>
    >>
    >> "wnfisba" <wnfisba@discussions.microsoft.com> wrote in message
    >> news:CCC8ACD0-EA7F-4152-8175-849FD7EBCDE5@microsoft.com...
    >> >I have an Access Database application that actually ODBCs to a SQL
    >> >Server
    >> > Database.
    >> >
    >> > Is there anyway I can determine what ODBC the Access Database is using
    >> > to
    >> > access the SQL Server Tables from within the Access Dtabase
    >> > Application???
    >> >
    >> > Thanks in advance for your help...

    >>
    >>
    >>
     

Share This Page