I need to create or replace a permanent query in access (like a view in oracle, postgres...), but from vb6 using ADODB.
i know that i can create and alter tables using a ADODB connection object with something like this
dim obj as new adodb.connection
obj.execute "create table ......:"
but, how to create the views?????