Printing table definitions

S

Susan

I am trying to print the database structure. I selected
Tools, Analyze, Documenter. Then I select the database to
analyze. I would like to change the options for the
print. If I select Options and try to print I
get "Application-defined or object-defined error" and it
will not print. As long as I do not select Options it
will print but prints on 4 pages. If I can set my options
it will print on one page. I Should explain that as long
I am signed on as administrator I can print print, but the
students can not print since they are logged on as a user.

HELP HELP HELP.
 
D

Duane Hookom

You should open a module and check for MISSING references. Make sure your
application compiles with no errors. After running the documenter you can
link the resulting table into your mdb and create a query for your own
report.

Link to the table C:\Documents and Settings\You profile\Application
Data\Microsoft\Access\ACWZUSRT.MDT;TABLE=doc_tblObjects

SELECT doc_tblObjects.Name AS TableName, doc_tblObjects_1.Name AS FieldName,
doc_tblObjects_1.Extra2 AS FieldType, doc_tblObjects_1.Extra3 AS FieldSize
FROM doc_tblObjects AS doc_tblObjects_1 INNER JOIN doc_tblObjects ON
doc_tblObjects_1.ParentID = doc_tblObjects.ID
WHERE (((doc_tblObjects_1.TypeID)=11));
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top