Retrieving/outputting database table and relationship info?

  • Thread starter Thread starter SirPoonga
  • Start date Start date
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.
 
If you have Access 2003, go to Tools|Analyze|Documenter. If you don't, there
are some third party apps that will do this.
 
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?
 
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.
 
I would have to do it in code by going through each table/field and
outputting to a string.
 
I would have to do it in code by going through each table/field and
outputting to a string.
 
You must log in or register to reply here.

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

linking tables and relationships 3
Database design many to many relationships 4
New Database - need help defining keys and relationships 3
Relationships between multiple tables 5
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Problems with query relationships in linked foxpro database tables 3
relationships 1
Exporting query to table in external database 4

Back
Top