Table/Query Types

P

pbewig

I know how to iterate over CurrentDb.Containers("Tables").Documents to
get a list of all the table/query names in a database. How can I
determine which is a table and which is a query? How can I determine
the type of a table (linked or local) or the type of a query (local,
pass-through, union)?

Phil
 
D

Douglas J. Steele

Use CurrentDb.TableDefs and CurrentDb.QueryDefs, rather than
CurrentDb.Containers("Tables").Documents
 
Top