I would like to be able to read the SQL text associated with queries held in an access (97 or 2000) database.
I am using the ADOX.Catalog from the ADO ext 2.5 library.
Everything works fine until I try to access a querydef that is a MAKE TABLE query. At this point the process fails on trying to read the view. Has anyone got any suggestions as to how this can be done.
Unfortunately its only the MAKE TABLE querydefs I really need to get to!