Table/Query Types

  • Thread starter Thread starter pbewig
  • Start date Start date
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
 
Use CurrentDb.TableDefs and CurrentDb.QueryDefs, rather than
CurrentDb.Containers("Tables").Documents
 
You must log in or register to reply here.

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

Counting multiple memberships 1
Access Dcount (multiple criteria) 3
Update table macro 1
Access Splitting Access Table 0
Prevenatative Maintenance 4
Access Overflow error 3
Export table to txt file with a variable filename 0
Help with SELECT UNION 7

Back
Top