Reading Data from MSysACEs Table

[Mark Gambo]

I want to copy the Fieldnames and types (Number, Text, Date/Time etc.) from each table in a Access Database (XP) and I assume this information is contained in theMSysACEs Table. How do I go about reading data from this table? Or how do I copy the Fieldname, size and types, etc. for the Database into a text file?

[RobDog888]

Its the db schema that your asking about. A schema is the structural design of the dbs objects like tables, quereis, forms, reports, etc.
One way to get them out for a db is to use the Documentor feature of Access.

Tools > Analyze > Documentor...

It will output a report on your db objects that you select (table, query, form, etc.).

[Mark Gambo]

Its the db schema that your asking about. A schema is the structural design of the dbs objects like tables, quereis, forms, reports, etc.
One way to get them out for a db is to use the Documentor feature of Access.

Tools > Analyze > Documentor...

It will output a report on your db objects that you select (table, query, form, etc.).

Thanks Rob!

[RobDog888]

No prob.

I wasnt sure if you wanted this by code, but if so you can use ADOX to do something similar.

[Mark Gambo]

No prob.

I wasnt sure if you wanted this by code, but if so you can use ADOX to do something similar.

If you had ADOX Code I would like to take a look at it! I want rather be able to do this via VB6 instead of Access.

[RobDog888]

I havent use ADOX yet as I havent really needed to do that yet. I know there was some code in the db forum I think that did it.
You may want to search on it. If you find it or something that does it using ADOX, it would be nice to see it too.

ADOX is nothing more then an extension of ADO. It can do some of the detailed stuff you need.

[Mark Gambo]

I havent use ADOX yet as I havent really needed to do that yet. I know there was some code in the db forum I think that did it.
You may want to search on it. If you find it or something that does it using ADOX, it would be nice to see it too.

ADOX is nothing more then an extension of ADO. It can do some of the detailed stuff you need.

Just in case you or someone else was interested I found the following post:

ADO Table Collection

and the attached Application that uses DAO.

[RobDog888]

Thanks for posting the link. I knew it wouldnt be too hard. Just need to know what to use .