Reading Data from MSysACEs Table
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?
Re: Reading Data from MSysACEs Table
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.).
Re: Reading Data from MSysACEs Table
Quote:
Originally Posted by 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.).
Thanks Rob! :thumb:
Re: Reading Data from MSysACEs Table
No prob. :)
I wasnt sure if you wanted this by code, but if so you can use ADOX to do something similar.
Re: Reading Data from MSysACEs Table
Quote:
Originally Posted by RobDog888
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.
Re: Reading Data from MSysACEs Table
I havent use ADOX yet :blush: 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.
1 Attachment(s)
Re: Reading Data from MSysACEs Table
Quote:
Originally Posted by RobDog888
I havent use ADOX yet :blush: 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.
Re: Reading Data from MSysACEs Table
Thanks for posting the link. I knew it wouldnt be too hard. Just need to know what to use . :)