Results 1 to 3 of 3
  1. #1
    triley01 is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2009
    Posts
    3

    run-time error '3151' odbc connection failed in Access 2003

    Hello, We have an Access FE application connecting to a BE SQL 2005. Recently we changed SQL servers, new name, ip and dsn. I created a new ODBC, then went into Access and changed the Link tables to reflect the new ODBC. I am able to update the tables to the new SQL server but when I try to run a Form that is used to update our Territories I get the "run-time error '3151' odbc connection failed" error. It sends me to VB code and here is where I get lost. I tried to review the code to see if the old db is hardcoded somewhere but couldn't find anything.



    Any suggestions to correct this would be greatly appreciated! Tim

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    when in the FE; you are able to open all/any table and change data?? (be sure to close that table and reopen it to sanity check if the data change actually occurred)

    if not - it has nothing to do with the form - - - your table link still isn't working

    if so...it is odd that the form would have a problem; check the record source of the form - - if it is a query - - run that query directly and see what happens....if it fails double check the tables that this query is using...

  3. #3
    triley01 is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2009
    Posts
    3
    Thanks! That did help. It turns out a Pass Through Query was referencing the old ODBC. Once updated the Form worked perfectly! Tim

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

Similar Threads

  1. ODBC and Long Query Time
    By pdouglas in forum Access
    Replies: 0
    Last Post: 07-09-2009, 10:21 AM
  2. Linked tables and ODBC connection strings
    By cwcadm in forum Import/Export Data
    Replies: 7
    Last Post: 05-26-2009, 07:30 PM
  3. Replies: 0
    Last Post: 05-14-2009, 12:34 AM
  4. [Access 2003] Displaying 24 Hour Time
    By Trainman in forum Access
    Replies: 4
    Last Post: 03-18-2009, 06:34 PM
  5. Replies: 1
    Last Post: 12-09-2005, 09:16 PM

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 - Senior Forums