Re: How can I report the metadata in an Access database?
From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 12/07/04
- Next message: kml665: "How do I set a text field in a table to be case sensitive?"
- Previous message: S Jackson: "Duplicate Data"
- In reply to: JimLudden: "Re: How can I report the metadata in an Access database?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 6 Dec 2004 16:00:50 -0800
Glad you found my John Viescas Table Documentor useful Jim.
Thanks for the feedback.
-- Jeff Conrad Access Junkie Bend, Oregon "JimLudden" <JimLudden@discussions.microsoft.com> wrote in message news:369A7389-D137-46A4-88A1-8F0D8B562B07@microsoft.com... > Thanks to both of you. The John Viescas version was what I need - it creates > a new table with the metadata. In my case I needed to add Business > definitions for every column - the the JV documentor gives me the room to do > that when I don't have write access to the source database. It gives a > startup to creating a metadata repository for the (linked) database. > > "Jeff Conrad" wrote: > > > For a list of database objects: > > > > I would suggest you try my new "Doug Steele Object Documentor" Add-In for Access. This > > add-in will create a nice report of all your database objects for easy reference. The report will > > list all the objects by category in alphabetical order in a three-column layout. It looks very sweet > > in my opinion and it's even easier to use than the Access Documentor. Plus, you get a nice report > > saved in your database that you can open again any time you wish! There is one version for Access 97 > > and another version that works for 2000, 2002, and 2003. > > > > After installing, which takes all of about a minute to do, you simply do: > > Tools | Add-Ins | Doug Steele Object Documentor > > That's it! Poof! A nice slick report created in your database in just a couple of seconds. > > > > You can find the free Add-In on MVP Doug Steele's site here: > > > > http://members.rogers.com/douglas.j.steele/Documentor.html > > > > For a list of Table Fields here are a few options: > > > > 1. If you need just one you could try Tools | Analyze | Documentor. > > That will print out the fields and a whole bunch of other information as well. > > You could do all the tables as well, just be careful which options you select. > > > > 2. See Allen Browne's site for some sample code: > > http://members.iinet.net.au/~allenbrowne/func-06.html > > > > 3. As another option I created an Access Add-In called the "John Viescas Table Documentor" that will > > list each table and its field properties in an easy-to-read format. It is even easier to use than > > the built-in Access Documentor and creates a slick report right in your database that you can just > > open again any time right from the Database Window. You could customize the report even more to your > > liking if you desire. > > > > Once installed all you have to do is Tools | Add-Ins | John Viescas Table Documentor. Poof! After a > > few seconds a slick report is displayed on the screen. In a nut shell the Add-In creates a new key > > table in your database, loops through each table (including linked ones) grabbing the information > > needed, writes all this information to the key table, creates the report entirely in code, saves it, > > and then displays it on the screen for you. That report can be opened again at any time since it is > > saved as a new report object in your database. Easy as pie! > > > > I am awaiting word back from John about the possibility of having him post it on his web site where > > anyone can download it. In the meantime I do not believe he would have a problem if I sent you a > > copy. If you do wish to have a copy please let me know where you would like it sent to (please mung > > the e-mail address so you won't get spammed). There is one version for Access 97 and one for 2000 > > which works with 2000, 2002, and 2003. > > > > -- > > Jeff Conrad > > Access Junkie > > Bend, Oregon > > > > "JimLudden" <JimLudden@discussions.microsoft.com> wrote in message > > news:EDB74AB1-8E86-4059-8751-FBFD0B741D66@microsoft.com... > > > Old versions of Access had a Database Documentor facility which was very > > > helpful but is no longer in the product. > > > Has anyone built this functionality into a set of VB modules that extract > > > the table, relationship, and column properties and put them into Access > > > tables for easy reporting? > > > > > >
- Next message: kml665: "How do I set a text field in a table to be case sensitive?"
- Previous message: S Jackson: "Duplicate Data"
- In reply to: JimLudden: "Re: How can I report the metadata in an Access database?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
