none
Tables Not Displayed in External Data Wizard RRS feed

  • Question

  • Experts- 

    I am trying to link to a table in another access db (from Access).  The database is password protected.  I can connect to the database OK, but when the wizard pops up which should show the available tables, nothing is displayed. 

    If I rather try and import the tables, they appear in the wizard.

    Any idea what is going on here?

    Thank you!


    Bonediggler

    Monday, December 7, 2015 3:30 PM

Answers

  • Hi Bone,

    You can't link to a linked table from another database. If you import it, you actually get a link instead.

    • Marked as answer by Bonediggler Tuesday, December 8, 2015 10:44 PM
    Monday, December 7, 2015 8:49 PM

All replies

  • Hello Bonediggler,

    Without looking at it and based on the limited information I can only guess that perhaps the Tables are hidden? If this is the case, you need to unhide them. Or use a manual means to accomplish the connection.

    Hth


    Just takes a click to give thanks for a helpful post or answer.
    Please vote “Helpful” or Mark as “Answer” as appropriate.
    Chris Ward
    Microsoft Community Contributor 2012

    Monday, December 7, 2015 8:10 PM
  • Hi Bone,

    You can't link to a linked table from another database. If you import it, you actually get a link instead.

    • Marked as answer by Bonediggler Tuesday, December 8, 2015 10:44 PM
    Monday, December 7, 2015 8:49 PM
  • Hello Hth

    The tables are not hidden.  What are the details of the manual means you are referring to?


    Bonediggler

    Tuesday, December 8, 2015 4:45 PM
  • Hello Hth

    The tables are not hidden.  What are the details of the manual means you are referring to?


    Bonediggler

    Hi Bone,

    Not sure if you saw my post. The tables don't have to be hidden. If they were linked tables, then the Wizard won't allow you to link to them through the other database. You have to import them, which is actually "linking" the tables from the original database - not the one you're selecting from the Wizard.

    Hope that makes sense...

    Tuesday, December 8, 2015 5:09 PM
  • Hello DB guy

    Good catch!  The table I was trying to link was actually itself a linked table.

    Importing did the trick.


    Bonediggler

    • Marked as answer by Bonediggler Tuesday, December 8, 2015 10:44 PM
    • Unmarked as answer by Bonediggler Tuesday, December 8, 2015 10:44 PM
    Tuesday, December 8, 2015 10:43 PM
  • Hi Bone. You're welcome. Glad to hear you got it sorted out. Chris and I were happy to assist. Good luck with your project.
    Tuesday, December 8, 2015 11:05 PM