Tables Not Displayed in External Data Wizard

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

Answer 1

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

Answer 2

Hi Bone,

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

Answer 3

Hello Hth

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

---

Bonediggler

Answer 4

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...

Answer 5

Hello DB guy

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

Importing did the trick.

---

Bonediggler

Answer 6

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.