Identifying linked tables 1

[LHWC]

Not sure if i should post here or forms forum, but here it is:
I have a form that populates a cbx on load. The code works well, except that i would like to limit the type of table displayed to only linked tables. Currently i have an IF clause that excludes SYS and TMP tables, but some tables are displayed that i want to prevent the user from accessing. I use A2002 DAO.
I saw a post (thread 700-742688) that seems promising except it's for ADO. It looks for tbl.type = "LINK". I know DoCMd.transferSpreadsheet has acLink as a modifier. How can i identify linked tables in DAO?
Thanks in advance!

 

[RickSpr]

Test the TableDef.Attributes property for dbAttachedTable. If the bit is on, it's a linked table.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[LHWC]

Thanks Rick, worked like a charm!