Results 1 to 6 of 6
  1. #1
    hol521 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    3

    Updated to 2010, created a new System ODBC - how can I change the old ODBC connection

    I use an ODBC connection to connect my Access database to the "Data Warehouse" at my university (this database was created by someone else years ago and uses Oracle 11g). I just updated to Windows 7 (64-bit) and moved to Access 2010 (though I still have 2007 on my computer). I created a 32-bit ODBC connection (which works fine) but I cannot figure out how to change where my macros go to "look" for the ODBC connection so that I can refresh my report.

    Sorry that I don't know the proper lingo - but I need help! My Dean needs this report in 11 minutes

    Thanks for reading!


    Holly

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Right click on the linked table(s) in question and open the linked table manager. From there you can refresh your links.

  3. #3
    hol521 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    3
    Thanks for reading and replying Stingaway. Unfortunately the Linked Table Manager option is grayed out when I right click on one of the tables. Any other ideas?

    Holly

  4. #4
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Is your database split front end and back end? The only reason I can think of that the linked table manager would be greyed out is that there aren't actually any linked tables... Can you post a screen shot of the tables?

  5. #5
    hol521 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    3

    Screenshot attached

    Screenshot attached - please let me know if I can show anything else!

  6. #6
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Ok those tables in your screenshot do not appear to be linked tables.. they look like they are imported tables. A linked table would show up with an arrow and a globe or an arrow and an excel icon, or something similar. (See attached example of what a form vs. linked ODBC table / linked Access table look like.)

    If you re-import your external data and choose "Link" instead of import, you should be able to set this up to where you can connect to the tables live instead of importing as static.
    Last edited by Stingaway; 10-25-2011 at 08:03 AM. Reason: Added example pic

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

Similar Threads

  1. ODBC connection and splitting the DB
    By crowegreg in forum Access
    Replies: 3
    Last Post: 08-30-2011, 11:02 AM
  2. Test for valid ODBC connection
    By jgelpi16 in forum Programming
    Replies: 1
    Last Post: 06-10-2011, 01:39 PM
  3. ODBC 32 to 64 Bit connection error
    By mgmtexecit in forum Reports
    Replies: 0
    Last Post: 03-30-2011, 10:06 AM
  4. ODBC 32 to 64 Bit connection error
    By mgmtexecit in forum Access
    Replies: 1
    Last Post: 03-30-2011, 10:05 AM
  5. ODBC connection
    By avicenna in forum Import/Export Data
    Replies: 2
    Last Post: 08-02-2010, 02:33 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