I wam wanting to write a application that opens a access database and searches through all the reports.
for each report i want the application to identify what each one does..
i.e. what tables it uses, sort bys, group bys e.t.c.
However when you open a report, you cannot see any source code.
I thought my only chance was to parse the syntax and use a string compare function to identify keywords and then produce a word document for each report that the owners of the database then can use to identify what each of their reports do.
The reason being...my customer has 150 reports and cannot remember what each one does.