Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to get Access 2010 database schema.

Posted on 2013-01-24
10
Medium Priority
?
673 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

877 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