Printing Access Table Definition

[Guest]

How can I get a print out of an Access Table Defintion???

The data types...the precision...and scale, and etc..

Thanks in advance....

wnfisba

 

[Albert D. Kallal]

you can get a nice
columnar listing of the field names using the database documenter. Remember
to use the options settings before printing these reports, else you do NOT
get a columnar listing, you get a tabular list, and this will use up way too
many trees (paper) in the process!

tools->analyse->documenter

Play around a bit with the settings before you actually hit the print
button...

 

[Guest]

Try Access MVP Jeff Conrad's free add-in known as CSD Tools:

http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

This is the perfect answer to my question, except that whenever I hit the
"options" button, Access fatals out. I can take the default report and
manually edit out the exdtra information. I will also look at the tools
suggested in further posts.

 

[Guest]

Hi EJ,

You've definatly got some type of problem with your installation of Access,
because you should not be getting a fatal error by clicking on the options
button. Try the following steps. You possibly have other wizards that are not
functional as well.

Replace three files on your hard drive, Acwzmain.mde, Acwzlib.mde and
Acwztool.mde, using the instructions shown in KB 303769. One or more of these
files may have become corrupted. Do this without Access running.

http://support.microsoft.com/?id=303769
http://support.microsoft.com/?id=833220 (Error in loading DLL)

1.) Insert the Microsoft Office or Access compact disc.
2.) By using Windows Explorer, open the Pfiles\Msoffice\Office\1033
folder on your CD-ROM or DVD-ROM drive, and locate the
Acwzmain.mde, Acwzlib.mde and Acwztool.mde files.
3.) Select these files, and then click Copy on the Edit menu
4.) Open the folder that you installed Office into. The default folder is
C:\Program Files\Microsoft Office. Select the Office\1033 folder,
and then on the Edit menu, click Paste.

If that doesn't fix the problem, try re-registering the Accwiz.dll,
Msado15.dll and DAO360.dll files. Click on Start > Run. Then enter the
commands:

Regsvr32 Accwiz.dll
Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

Make sure to include the double quotes, as indicated in the above two
examples. In rare circumstances, you may find that the msado15.dll and/or
dao360.dll files are in a different folder. In that case, just adjust the
indicated path accordingly.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________