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
 
Back
Top