Access Queries

[Mauricio Olivier]

Hello all,

I need to know how to list all the queries of an access DB from VisualBasic,
to see the code of the queries and use it to build a report with those
codes.

 

[[MVP] S. Clark]

Via DAO, traverse the Querydefs Collection.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Mauricio Olivier]

Thanks I'll try it, but can I do it with ADO??