How to get list of tables from access database ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm writing a dynamic tool to get structure of access databases.
I search the way to get the lit of tables.

I try from C# the request :
SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Type=1 AND
MSysObjects.Name NOT LIKE 'MSys*'

This works, only if the MSysObjects is set to "read ok" in the security
option.

Somebody know another way ?

Thanks
 
Hi
What you can do it to load your database into XML setting enforce schema on
then you can write this schema that represent the structure of your
database

Mohamed Mahfouz
 

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

The purpose of these query 2
Table Documentation 1
>> List of database queries 4
Finding a list of tables in Access from VBA in Excel 2
System Selected Table for Query/Report 3
Combo Box not listing linked tables 2
Combine multiple tables into one 8
The Book 2

Back
Top