Results 1 to 4 of 4
  1. #1
    heather is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    5

    System ODBC connections not appearing in Access ODBC Connection list

    I've a client machine that has been having ODBC connection failures for months. So, after all sorts of diagnostics, testing, updates, etc, I finally reinstalled the operating system. Now I've a new issue that I'm stumped on. I created ODBC connections using the SQL Server Native Client 11.0 using Administrator (right click, run as). They test fine but when I go into Access, those System ODBC connections are not present. Only User connections. I've confirmed that I used the 32-bit ODBC from Syswow64\odbc32.exe.



    Client computer is a 64-bit, win 10, Access 2010.

    Any ideas?

    Thanks.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I have problems with this too. I now add the connection string thru VBA when the database opens and add it to all pass-thru queries.

  3. #3
    Yarbz is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    13
    Quote Originally Posted by heather View Post
    I've a client machine that has been having ODBC connection failures for months. So, after all sorts of diagnostics, testing, updates, etc, I finally reinstalled the operating system. Now I've a new issue that I'm stumped on. I created ODBC connections using the SQL Server Native Client 11.0 using Administrator (right click, run as). They test fine but when I go into Access, those System ODBC connections are not present. Only User connections. I've confirmed that I used the 32-bit ODBC from Syswow64\odbc32.exe.

    Client computer is a 64-bit, win 10, Access 2010.

    Any ideas?

    Thanks.
    Heather, I just had this same problem, switching from 32-bit to 64-bit in OS 10 and 2016 office.
    I had to go into the ODBC source as Admin and establish a 64-bit ODBC connection.
    Then Access (in 2016 as a 64-bit) could see the new connection and I could run the connections and open the tables.
    64-bit Access could not see the 32-bit ODBC.
    Hope this helps.
    Yarbz

  4. #4
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    If you have a working and non working machine within the same network, try exporting registry entries for ODBC and merging them to the machine with issues.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-02-2015, 09:44 AM
  2. MS Access Reading from ODBC Connection
    By fadilrexhepi in forum Access
    Replies: 7
    Last Post: 02-12-2015, 06:17 AM
  3. Access ODBC connection issue
    By cm-net in forum Access
    Replies: 1
    Last Post: 10-06-2014, 01:25 PM
  4. Tracking ODBC Connections (Access 2010)
    By JeffGeorge in forum Access
    Replies: 9
    Last Post: 08-01-2014, 03:25 PM
  5. Replies: 5
    Last Post: 10-25-2011, 08:01 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums