Need to Export All Code - Not Data

E

Eric

We have a huge Access application where I work. For audit purposes we have
to count the number of lines of code for this application. This includes the
queries too. Is there a utility that will allow me to export the SQL for
every query and the code for every form, report, module, etc?

With more than 500 elements in this database it will take more than a week
to simply export all the code.

Thanks
 
D

Douglas J. Steele

Sorry, I should have been more explicit.

MZ Tools will give you line counts per module in the application.

Exporing 500 elements to another database should take you minutes, not days.
Take a look at what Arvin Meyer has at
http://www.datastrat.com/Code/DocDatabase.txt or what I had in my February,
2005 "Access Answers" column in Pinnacle Publication's "Smart Access" for an
undocumented way to export everything into Ascii files. (You can download my
column, and a sample database, for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html)
 
S

Steve Sanford

And for the D-I-Y group, check out Albert D. Kallal's site at

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

under the section "Lines of Code".

It is an A97 mdb (zipped) but converts no problem.

Although Albert says "This is VERY rough code,....", I modified it to print
to a text file instead of the immediate window in the IDE and added code to
pick the directory and file name.
 
Top