Solved

How to get Access 2010 database schema.

Posted on 2013-01-24
10
583 Views
Last Modified: 2013-01-29
Hey Experts,

I have a database in Access 2010.  Is there a way to create a report or export the entire database schema?

I can do individual tables, but with over 100 tables, I need a compilation report instead.

Thanks.
0
Comment
Question by:Modifier1000
  • 4
  • 2
  • 2
  • +1
10 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 38815975
have you tried using the Database Documenter

Database tools > Analyze group
0
 
LVL 26

Expert Comment

by:jerryb30
ID: 38815994
Are you just trying to get table and field names as well as data types?
0
 

Author Comment

by:Modifier1000
ID: 38816353
@capricorn1
I don't get an Analyze Group option.  Only Analyze Performance and Analyze Table

@jerryb30
yes, for all tables (over 100 tables)
0
 
LVL 75
ID: 38816369
Total Access Analyzer with do this and a LOT more:

http://www.fmsinc.com/MicrosoftAccess/BestPractices.html

Great tool.

mx
0
 

Author Comment

by:Modifier1000
ID: 38816387
@DatabaseMX
Thanks, do ya know about any free tools?
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:Modifier1000
ID: 38816391
I'm just surprised Access does not already have a tool installed for something like this.
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 38816441
see this

x
0
 
LVL 75
ID: 38816447
Free ... not really, other than built in tool already mentioned.

mx
0
 
LVL 26

Expert Comment

by:jerryb30
ID: 38816637
For simple documentation (tables-fields-datatype)
try:
http://www.helenfeddema.com/access.htm
Look for 150, Listing table and query fields.
Can be adapted for lots of other field properties.
0
 

Author Closing Comment

by:Modifier1000
ID: 38833711
This is nice, though I could not get it to work with all the tables at once, I could get A LOT of info per table.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now