Object Documentor

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
Mark said:
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.
Click to expand...

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.
 
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
Click to expand...
Data\Microsoft\Access\ACWZUSRT.MDT", acTable,
 
Back
Top