Need to Export All Code - Not Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top