Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ODBC Query (Excel 97, Access 97)

    I just finished creating a Query using ODBC on my system. If I want to use this spreadsheet with the macros that retrieve the data from access on a different PC do I have to load ODBC or anything else?

    What is a different User on a different PC want to use this do I have to load ODBC or change anything?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: ODBC Query (Excel 97, Access 97)

    Hi Daniel

    Yes you would need to have the ODBC drivers. Now luckily ODBC is very common and it is installed with some default installations of Windows and/or databases. Access also has a common driver. But just to be on the safe side check the following MSKB Article ID: Q156835

    Having the ODBC drivers is one aspect of it, you still may need to have a DSN entry for your ODBC connection.

    I wish I had a clear source for you to look at, but I have not found any... Maybe you an scan the MSKB for some.

    I hope this helps.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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