Retrieving/outputting database table and relationship info?

S

SirPoonga

Is there a way in Access, either with the program or through code, to
get table/field information ans relationships?

I was given the taskt o redo a database that has many tables. The
table have many fields in common. I am trying to figure out and easy
way to compare what fields are common between the multiple tables.
 
W

Wayne Morgan

If you have Access 2003, go to Tools|Analyze|Documenter. If you don't, there
are some third party apps that will do this.
 
S

SirPoonga

Thanks. I have Access 2000, but it has this utility too.

Follow up question. Can I output the table information as a CREATE
statements like phpMyAdmin does with MySQL backups?
 
W

Wayne Morgan

I haven't used MySQL. If you are wanting to create Make Table queries; yes,
you can make those types of queries, but Access won't automatically export
the tables as Make Table queries.
 
S

SirPoonga

I would have to do it in code by going through each table/field and
outputting to a string.
 
S

SirPoonga

I would have to do it in code by going through each table/field and
outputting to a string.
 
Top