can you update a stored query in MS Access using C#?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have an application and Access DB that i deployed. i can't get into the
machine that it's been installed on and i have to update one of the queries
that i created in the DB itself. i've just started to experiment with the
automation of Access 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?

Thanks for any help.
 
Quick and dirty you can use DAO from say another Access db. Look at
DAO.QueryDef. If you need a permanent solution look at ADOX.
 
carion1 said:
Quick and dirty you can use DAO from say another Access db.
Click to expand...

i can't do it that way. the machine is a seven hour drive and i can't get
into their network and the people who i woud to rely on to do anything there
are very good with computers.
Look at DAO.QueryDef. If you need a permanent solution look at ADOX.
Click to expand...

Are there any tutorials on how to use querydef or ADOX? i'm trying to write
it in C# and it's a one time deal. i ju
 
Back
Top