Results 1 to 4 of 4
  1. #1
    MrMarmite is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2020
    Posts
    4

    Question Adding tables to aleady-linked ODBC

    Hi,

    I have set up an ODBC to connect to PostgreSQL dB. That's all working as desired. However, the database now has a couple of new tables, and I can't work out how to add these without deleting and re-adding the connection. Refresh and Relink don't seem to do this,



    Any help most welcome,

    Cheers

    James

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,279
    this is exactly what Relink is for.

    if normal relink wont work, you my try the checkbox ALWAYS PROMT NEW LOCATION.
    then select the source again.
    this always works.

  3. #3
    MrMarmite is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2020
    Posts
    4
    Thanks...where is that checkbox? I am looking at the linked table manager

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,473
    The linked table manager is to refresh the links or change the location/source of the existing tables. To add new tables you need to click on the External Data, Import, ODBC and select your connection to the external db and in there select the new tables you want to add (don't forget to check the Save Password towards to end so you don't get prompted every time you open the front-end).

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 16
    Last Post: 01-09-2019, 09:44 PM
  2. Combining ODBC linked tables
    By sirlosi in forum Queries
    Replies: 7
    Last Post: 03-10-2011, 02:43 PM
  3. ODBC Linked tables Error
    By tpcervelo in forum Access
    Replies: 0
    Last Post: 02-10-2011, 01:40 PM
  4. Linked tables and ODBC connection strings
    By cwcadm in forum Import/Export Data
    Replies: 7
    Last Post: 05-26-2009, 07:30 PM
  5. ODBC Linked Tables Become Unupdateable
    By dollardeveloper in forum Access
    Replies: 0
    Last Post: 04-08-2009, 07:13 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