Link Table Manager

G

Guest

About three weeks ago I had a problem with the Link Table Manager not showing
a new table I had added. A kind MVP gave a solution that worked, which was to
use the Link utility via the File > Get External Data > Link Tables. Now none
of the tables are shown in the Link Table Manager even after I use the File >
Get External > Link Tables method.
Does anyone have a solution, or a tip where I can research a possible
solution?

TIA
Steve COA-NM
 
D

Duane Hookom

Do you have any linked tables? All linked tables should display in the
linked table manager.
 
D

Duane Hookom

If you don't have any linked tables, you can't expect to see any linked
tables in the Link Table Manager.
 
G

Guest

Sorry I misunderstood your question. I link all the tables in the database
using the File > Get External Data > Link Tables process. But after that
successfully operation none of the Tables appear in the Link Table Manager.

TIA
 
D

Duane Hookom

Make sure the linked tables aren't hidden.
Check the description property of the linked table in design view.
Compact the database.
Turn off all Name Autocorrect options
Check the linked table manager in other MDBs
Use your own code to re-link tables rather than the LTM.
http://www.mvps.org/access/tables/tbl0009.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top