Re: How can I report the metadata in an Access database?
From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 11/30/04
- Next message: Jeff Conrad: "Re: How can I report the metadata in an Access database?"
- Previous message: wheeler: "RE: How can I set up a form for users to add signatures"
- In reply to: JimLudden: "Re: How can I report the metadata in an Access database?"
- Next in thread: JimLudden: "Re: How can I report the metadata in an Access database?"
- Reply: JimLudden: "Re: How can I report the metadata in an Access database?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Nov 2004 16:54:47 -0800
Hi Jim,
No problem, a copy is being sent now. I sent it to the address listed in your posts.
Follow these steps to install the Add-In:
1. Unzip the file JVTableList.MDA to your Office or Access directory to easily find it when we
install the Add-In.
2. Now open any Access database and go up to "Tools" on the main Access menu bar. From there go down
to the option called "Add-Ins". This sub-menu will list any installed Access add-ins on your system,
as well as an option called "Add-In Manager". Click on the option called "Add-In Manager" and a new
screen will appear.
3. The box will display a list of available add-ins on the left side. Depending upon where you
unzipped the add-in file, you may see the John Viescas Table Documentor already listed in this box.
If the file is listed, click on the option to highlight it and then press the "Install" button to
complete the installation. There should now be a little "x" next to the option meaning it has now
been installed. If you do not see the add-in listed in this box simply click the button called "Add
New..." where you can browse for the location of the file. Once you find the file and click on it in
the browse window, you will be taken back to the Add-In Manager screen. Now you should see our
add-in listed in the box with a "x" by it meaning it has been successfully installed. If not,
highlight the option and then press the "Install" button to complete the installation. Hit the
"Close" button on the Add-In Manager when finished. That's it, now we're ready to use the utility!
4. To launch the add-in, simply open any database you wish to document and go up to Tools | Add-Ins
and click on the new option "John Viescas Table Documentor". Depending upon the number of tables in
your database (and whether they are linked or not), the utility should only take a few seconds to
create the report and display it on the screen. Once on screen you can either print the report or
just view the different pages. The utility creates a new report object in your database called
"rptzvTableFields" and a new table called "zvTableFields". If you wish to view the report again, you
can simply open the report in the Database Window or re-run the add-in utility if you have
added/changed/deleted new fields and/or tables. You can delete these database objects if you do not
wish to have them in your database.
Please post back to the newsgroup when you receive the file and if you have any problems . The
e-mail was being sent from a "dump" e-mail account and will not be checked if a reply is sent. The
only way I will know if you received the file is through the newsgroup.
Hope you find it useful.
-- Jeff Conrad Access Junkie Bend, Oregon "JimLudden" <JimLudden@discussions.microsoft.com> wrote in message news:F7D2F0C2-5478-4CA6-9CB9-2746E3EF7ED1@microsoft.com... > I really could use a copy of John Viescas Table Documentor for Access 2000. > Send to <<e-mail address snipped>> > Many thanks :) > > "Lynn Trapp" wrote: > > > AFAIK, it is still there but may have moved to a different menu location. > > What version of Access are you using? > > > > -- > > Lynn Trapp > > MS Access MVP > > www.ltcomputerdesigns.com > > Access Security: www.ltcomputerdesigns.com/Security.htm > > > > > > "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: Jeff Conrad: "Re: How can I report the metadata in an Access database?"
- Previous message: wheeler: "RE: How can I set up a form for users to add signatures"
- In reply to: JimLudden: "Re: How can I report the metadata in an Access database?"
- Next in thread: JimLudden: "Re: How can I report the metadata in an Access database?"
- Reply: JimLudden: "Re: How can I report the metadata in an Access database?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
