Property to determine if table is a link table

J

jimt

I've seen it before (many years ago) but can't find how its done in the KB or
newsgroup; but, what table property can be used to determine if the table is
a link table?

Thanks
Jim T.
 
A

Albert D. Kallal

hit ctrl-g and in the debug window type in:


? currentdb.TableDefs("tblName").Connect

If there somthing in that above, then it is a linked table....
 

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

Similar Threads

Word VBA - Want to test if Full Name is NOT Present in document 0
Create a chart from a table in word thats dynamic 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Macro to copy table of contents to a new doc 0
Creating a Search using a combo box and then creating a report. 4
Dealing with a Pivot Table (when I don't want to) 0
How to delete cut & repost a table 0
Insert Index into a Table 1

Top