How can I change query definition in Access database from VB. I need this for upgrading current database tu new version.
I have to add one more field from table that is already define in this query.
example:
Current
select tab1.field1, tab2.field2 from tab1, tab2 where ....
changed to
select tab1.field1, tab1.field2, tab2.field2 from tab1, tab2 where ....
Thanx!




Reply With Quote