retrieve SQL string from Access View/Query

[highwray]

I am trying to retrieve the SQL string from an Access View using C#. I have searched the web (including MSDN) and cannot find anything that helps me. I am NOT trying to run the SQL or use the resulting View - I have no trouble with that at all - I just wish to extract the SQL statement string.
Any help would be much appreciated.

[PianoMan64]

From what I remember about MS Access, that isn't something that is possible. There isn't any methods that I know of that are available that gives you that kind of access.

Within VBA, you have the option of specifying a query in code and then saving that to a query within the database, but not something that would controlled external of MS Access.

Is there some reason you need the SQL Query from access??

[highwray]

Thank you very much for your response, but I have now managed to retrieve the SQL string using C#.
Kind regards
Michael