Object Documentor

[Mark]

Hello,

I seem to remember in Access 97, I could use the
documentor to create a report of the queries I've
written, and then Save As the results to a table. Does
Access XP no longer allow that function, or is there an
alternate way to do this?

Please help. I have 500 queries to search, and I really
don't want to do this the hard way.

Thanks

Mark

 

[Dirk Goldgar]

Hello,

I seem to remember in Access 97, I could use the
documentor to create a report of the queries I've
written, and then Save As the results to a table. Does
Access XP no longer allow that function, or is there an
alternate way to do this?

Please help. I have 500 queries to search, and I really
don't want to do this the hard way.

Huh, I hadn't noticed that. It does look like the Save As Table menu
item is gone. But the Documenter utility actually captures this
information in its own table, in a special database file called
ACWZUSRT.MDT in your personal Application Data folder; e.g.,

C:\Documents and Settings\Mark\Application
Data\Microsoft\Access\ACWZUSRT.MDT

The table is named "doc_tblObjects", and it persists even after you
close the Documenter report. So you can open that database directly in
Acc, or link to the table in that database like this:

DoCmd.TransferDatabase acLink, "Microsoft Access", "C:\Documents and
Settings\Mark\Application Data\Microsoft\Access\ACWZUSRT.MDT", acTable,
"doc_tblObjects", "doc_tblObjects"

(correcting the path for your installation), and work with the data.

Or you could export the Documenter's report to Excel and fix it up
there.

 

[Mark]

Thank you Dirk for your response.

I tried the Excel route already, but the queries are over
the 256 charactor limit for an Excel cell.

I'll try opening the MDT file though.

Have a great weekend.

Mark

-----Original Message-----


Huh, I hadn't noticed that. It does look like the Save As Table menu
item is gone. But the Documenter utility actually captures this
information in its own table, in a special database file called
ACWZUSRT.MDT in your personal Application Data folder; e.g.,

C:\Documents and Settings\Mark\Application
Data\Microsoft\Access\ACWZUSRT.MDT

The table is named "doc_tblObjects", and it persists even after you
close the Documenter report. So you can open that database directly in
Acc, or link to the table in that database like this:

DoCmd.TransferDatabase acLink, "Microsoft Access", "C:\Documents and
Settings\Mark\Application

Data\Microsoft\Access\ACWZUSRT.MDT", acTable,

 

[Jeff Conrad]

The following thread may be of some interest to you:

http://tinyurl.com/2ybva

Read the whole thread though.