New table in be missing in Linked Table Manager

[RenaG]

I am working in Access 2007.

I added a table in the be and now need to link it to the fe. When I launch the Linked Table Manager, it doesn't show up in the list. Am I missing a step?

TIA!

~RLG

 

[Beetle]

LTM is for managing existing links. If you created a new table you need to first establish a link to using External Data / Link Tables.

 

[RenaG]

Hey Beetle,

Thanks for the quick reply. When I went to External Data | Import | Access, (and filled out the "Select the source..." screen) I selected from the list the table I need to link to. When that window closes and I look at the table list, it shows the table with a 1 appended to the name. I think I may have earlier "imported" the table (even though it never showed up in the list) when I thought I was linking. Could that be causing me a problem now? I don't want the file with a 1 at the end of the name. I deleted it from the list and tried again with the same results. Suggestion?

TIA!
~RLG

 

[Beetle]

Yes, it sounds like you imported it as a local table instead of linking to it. Are you saying that table is not appearing in your table objects list as either a local or linked table?

 

[RenaG]

Ah, bingo! I hadn't scrolled up to the top of the linked table list but just now discovered that sure 'nuf, there it was as a local table. I deleted it and then did the Import | link step and now have it linked without a 1 at the end of the name.

Thanks so much for your help!

~RLG