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
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding data to MS Access from csv file 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Weekly Report 2
How to paste this down? 3
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
List all tables, including document structure 0

Top