Search results

Thanks Bob. I have achieved my goal with the use of interop (not ideal) Here is the code if anyone is interested. I converted it to c# as it is my preference:

I should have given more detail (as you requested initially bob, apologies) I am using vb.net....so DAO is not supported. I am currently connecting with OleDb.

I am trying to get the text that makes up the query. From my vb app I am connecting to my access database, I can see what queries there and can run them, but would like to be able to view the script before executing

Hi, Can I get the sql contents of a query programtically? Thanks