Solved

How to get Access 2010 database schema.

Posted on 2013-01-24
10
605 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

740 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