How can I create a query to database file by code.
How can I create a query to database file by code.
I can't get QueryDef to work cause my database connection is type of "connection" not "database"
Public db As Database <-- not
instead I'm using
Public db As Connection
It is esy to create tables with "CREATE TABLE" sql command.
Can't figure out how create QUERY.
EDIT: I working with a access database
Other solution might also be copying a query from un other database file but how would that then be done?
|
