question on how to update a query within an existing Access DB

[Guest]

I have an application and Access DB that i deployed. the machine that the app
and db are installed on is about 5 hours away and i don't have Access to it.
I have to update one of the stored queries that i created in the DB itself
and i am trying to come up with a simple way to make the change because it
will have to be done by someone who is not versed in computers. i've just
started to experiment with the
automation of Access using C# but not sure how to get control of the
specific query. is this the right approach? if so how can i get control of
the query and
change it? if not is there another way and are tutorials avaliable?

Thanks for any help.

 

[Mary Chipman [MSFT]]

One way to go about it is to use DAO -- there's a PIA (primary interop
assembly) for DAO so you can call it from C#. A saved query is a
member of the QueryDefs collection, and you can modfiy it's .SQL
property. You can also use Access SQL DDL, but I'm not sure of the
precise syntax.

--Mary