Results 1 to 3 of 3
  1. #1
    MattDyson1989 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    2

    Changing ODBC Data Source

    Good morning,



    I am having difficulty with my Access database, when I run a particular query. The query is linked to a table in SQL Server, but I keep getting a "ODBC -Call Failed" error message. After some research I understand I might need to change the ODBC Data Source, but this is something I have never done and am unsure of how to do it so my query will work!

    Any help will be most appreciated and please ask if you require more information.

    Thanks!

    Matt

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Is there VBA code involved to run the query? Do other objects rely on the same SQL BE?

  3. #3
    MattDyson1989 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    2
    It just requires 2 search parameters then is meant to execute the query. What do you mean by SQL BE?

    Thanks for your help.

    Matt

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

Similar Threads

  1. Replies: 8
    Last Post: 02-28-2014, 10:27 AM
  2. Change source of ODBC data
    By Alan Cannon in forum Access
    Replies: 1
    Last Post: 07-15-2013, 02:46 PM
  3. ODBC Data Source driver for Visual Foxpro
    By smytelka in forum Access
    Replies: 11
    Last Post: 01-02-2013, 09:03 PM
  4. Replies: 3
    Last Post: 01-06-2012, 04:17 PM
  5. Replies: 0
    Last Post: 08-30-2006, 02:50 AM

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