Results 1 to 3 of 3
  1. #1
    torunsu is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    9

    Connecting to database via ODBC

    Hi!



    I am working with an Access 2003 application, which consists of some linked tables. These are linked via ODBC. My question is: Is there any way to edit the odbc connection for all of these instead of changing for each linked table? If I want to change the database this is very time consuming. I do not want to change the odbc configuration on the computer itself.

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    All you need to do is to open the Linked Table Manager, and select all of the ODBC linked tables and then check the box to prompt for new location and then it will give you the dialog where you can select the DSN you want for those. I'm not sure what you mean by "for all of these instead of changing for each linked table."

  3. #3
    torunsu is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    9
    I figured it out, and that is the solution I came up with. Thanks anyway!

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

Similar Threads

  1. mysql connecting help....
    By alex_raju in forum Access
    Replies: 1
    Last Post: 07-18-2011, 07:22 PM
  2. Connecting sybase thru ms-access odbc
    By murali.kothuru in forum Queries
    Replies: 2
    Last Post: 08-01-2010, 10:00 PM
  3. ODBC -- call failed. | Oracle ODBC
    By drdexter33 in forum Access
    Replies: 1
    Last Post: 04-03-2010, 09:32 PM
  4. Database design - connecting 2 tables
    By Eisaz in forum Database Design
    Replies: 2
    Last Post: 10-16-2009, 09:19 AM
  5. Replies: 0
    Last Post: 02-16-2009, 08:21 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 - Senior Forums