Results 1 to 9 of 9
  1. #1
    MiaAccess is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2011
    Location
    Texas
    Posts
    31

    Linked table manager does not see a new table


    I created a TblUsers in the back end and when I new open the linked table manager in the front end, it does not show that table. It is not hidden. What happened, what do I do?
    Office 365Pro plus.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Link it in again.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You have to create a link to the new table. It does not happen automatically.
    Assuming the BE is an Access file, you don't use the Linked Table Manager, you click on External Data, then on ACCESS (in A2010 - don't have O365) - follow the wizard steps to LINK to a table..

    If you have a linked table and you MODIFY the table in the BE, then you would use the Linked Table Manager to refresh the linked table to show the changes to the BE table.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If you have a linked table and you MODIFY the table in the BE
    You mean modify the design? How do you modify the design in a linked BE table from the front end (notwithstanding code that you might run from the fe on a be database table, but why would you when you could just open the be and make mods from there)? Or did you mean something else?

    There is one other reason I've seen as the problem but not sure where I saw it posted. The user was opening the wrong back end to find the table.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Ok,Ok.... (yes, it wasn't especially clear/precise)
    If you open the BE in design view and add/delete/rename one or more fields, then you would use the Linked Table Manager in the FE to refresh the linked table to show the changes to the BE table.

    Howz this??

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Not bad - except if you modify a be table in that db and open that table in the fe, the new field is there anyway - even if the fe was already open. If the table was open in the fe (or I suppose had a lock on it) you can't modify that table in the be.
    At any rate, you don't have to relink to see the new field.

    I know you're going to try it when I'm not looking...

  7. #7
    MiaAccess is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2011
    Location
    Texas
    Posts
    31
    When I go to the linked table manager, it shows me all tables that a linked to he front end. It has been a long time since I programmed, but I seem to remember that there were tables that were not linked and therefore not checked.
    The BE has the new table I just added.
    I switch to the FE. The linked table manager shows me all tables which are already to the front end, but not the newly added table.

    Using your suggestion on line 2, that can only export the file to another file, not link.

  8. #8
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Using your suggestion on line 2, that can only export the file to another file, not link.
    That is incorrect. Note especially the 2nd pic.

    Click image for larger version. 

Name:	GetData.jpg 
Views:	6 
Size:	30.2 KB 
ID:	40981

    Click image for larger version. 

Name:	GetData2.jpg 
Views:	6 
Size:	31.1 KB 
ID:	40982

  9. #9
    MiaAccess is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2011
    Location
    Texas
    Posts
    31
    That is the step I was missing. Thanks for the pictures, was looking at the wrong thing. I got it. Solved

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

Similar Threads

  1. Linked Table Manager
    By CS_10 in forum Access
    Replies: 3
    Last Post: 03-22-2016, 06:02 AM
  2. Replies: 12
    Last Post: 06-19-2015, 10:02 AM
  3. Linked table manager error
    By jim_jim in forum Access
    Replies: 5
    Last Post: 08-25-2010, 08:06 PM
  4. Linked Table Manager Problem
    By tallerthantrees in forum Access
    Replies: 4
    Last Post: 08-17-2009, 03:58 AM
  5. Linked Table Manager
    By driccardi in forum Access
    Replies: 4
    Last Post: 02-15-2006, 11:47 AM

Tags for this Thread

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