You want to modify a *stored* query, you mean?<BR><BR>If so, the answer is "yes and no". You can't modify or remove ones that you put there from within the Access program, but you can add (and then remove) your own by way of ADOX. <BR><BR>Let's see...where did I put that link...<BR><BR>Oh yeah:<BR><BR>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/adocreateq.asp
Not really the question even though I'm 99% sure what I'm asking can't be done. Can you perform an insert or update (rows of data) to a query in Access or do I have to insert / update into each table individually. <BR><BR>I don't think it is possible but wanted a second opintion on it.