Update query statement 1

[mansii]

Framework 1.1

Condition:
I have a pre defined query in my MS Access database. The select query is:

SELECT recID, Field1 FROM Table1

Question:
Is it possible to physically/permanently change/update the query just the way we do in ALTER TABLE? ALTER QUERY maybe?

SELECT recID1, Field1, Remark1, Note1 FROM Table1

TIA
mansii

 

[chrissie1]

I think it should be possible with the access object library or with adox (could be tricky if the user has the wrong version of access) but I think this will be better answered in the access forum.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[RoyVidar]

You can work with "Jet stored procedures". I'm afraid it doesn't allow "Alter Proc", but do allow "Drop" and "Create".

Working with MS Access Stored Procedures in VB.NET. Part 1

Else, it is probably easier, to just open Access and play with the query tool;-)

Roy-Vidar

 

[mansii]

Roy,
A stright direction. I need to update huge databases separated in 30 provinces. It'd be easier to email them a small transaction application. That's the reason why I do not take take the "easier" step.

Christiaan,
I thought about that, too. Just like the Jet Engine tool.
I tried the Access forum with no luck because the are talking about VBA which related to Roy's "easier" way.

Anyways,
Thank you both for your time.

mansii