By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,036 Members | 960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,036 IT Pros & Developers. It's quick & easy.

Data dictionary for Access?

P: n/a
How can one get a complete data dictionary from an Access database?
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Click on Tools - Analyze - Documenter at the top of the screen.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"jeff regoord" <jh***@netzero.com> wrote in message
news:da**************************@posting.google.c om...
How can one get a complete data dictionary from an Access database?

Nov 13 '05 #2

P: n/a
PC Datasheet,
Yeah, but the output is a way to fat rtf file of limited usefulness. How
about something that can be queried, updates itself as objects listed in the
dictionary change, etc. I wrote one for a customer but since I've got SQL
Server in the form of MSDE I don't have to anymore. This last pass through
re-installing stuff I discovered I could get the SQL Server Enterprise
Manager snap-in to install in Microsoft Management Console. I've got a data
dictionary in the meta-data tools of SQL Server and it was free & legal.

"PC Datasheet" <no****@nospam.spam> wrote in message
news:0F*******************@newsread3.news.atl.eart hlink.net...
Click on Tools - Analyze - Documenter at the top of the screen.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"jeff regoord" <jh***@netzero.com> wrote in message
news:da**************************@posting.google.c om...
How can one get a complete data dictionary from an Access database?


Nov 13 '05 #3

P: n/a
tom
Alan,

How about querying the access data dictionary? (the "mSys" tables)

-Tom
. How
about something that can be queried, updates itself as objects listed in the
dictionary change, etc.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.