change table

[livia]

How can I change the table used by a querie with VBA?

 

[Allen Browne]

Assign a new string the the SQL property of the QueryDef, e.g.:

dbEngine(0)(0).QueryDefs("MyQuery").SQL = "SELECT FROM MyNewTable ...