MSysObjects

J

Jacob Petersen

In an SAS-application I'm making a tool for importing
tables from MS Access. I want to make a list of available
tables in the Access Database. Can I make a query on the
table MsysObjects to find these ? How about : select name
from MsysObjects where type = 1 and flags = 0 ?
 

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

Export Queries and Tables to Excel 2
Macro to Select text from a point given to a specific word 2
MSysObjects permissions 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Exists() function seems broken.. Any help? 19
Help creating a search form in Access XP 0
Cannot access foreign database Msysobjects - No read rights 2
Annoying Invalid path message from Link Specification 2

Top