export all sql statments

[ljb]

I need to consolidate several end user developed Access 2000 databases. To
help do it I need to see all sql found in the queries, forms and form
controls. Does anyone know how to export all this to a text file? I'm
familiar with VB, vbscript and somewhat familiar with Access VBA.

thanks
LJB

 

[Jim Richards]

-----Original Message-----
I need to consolidate several end user developed Access 2000 databases. To
help do it I need to see all sql found in the queries, forms and form
controls. Does anyone know how to export all this to a text file? I'm
familiar with VB, vbscript and somewhat familiar with Access VBA.

thanks
LJB


.
Simply copy all your *.qpr files to *.txt. One way you

can do this in a Dos/Command Prompt by using cmd "copy
<drive:\path\>*.qpr <drive:\path\>*.txt".

You can also just open your *.qpr files with Notepad using
right click on the file and selecting open with, then
Notepad when in Windows Explorer.

 

[Jim Richards]

-----Original Message-----
I need to consolidate several end user developed Access 2000 databases. To
help do it I need to see all sql found in the queries, forms and form
controls. Does anyone know how to export all this to a text file? I'm
familiar with VB, vbscript and somewhat familiar with Access VBA.

thanks
LJB


.
Disregard my previous message....Brain fart to Foxpro.

In Access 2000 you can open the database in design mode
then go to the Tools Menu bar, Select Analyzer, then
Documentor. From their you can export to variety of
choices such as rich text format. Also I think you can
port access database to Visual Basic - See help in Access
2000 for exporting and converting. Hope this helps.