Solved

How to get Access 2010 database schema.

Posted on 2013-01-24
10
594 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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
 

Author Comment

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

Accepted Solution

by:
Rey Obrero (Capricorn1) 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 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