I was wondering if anyone could point me to resource that explains how to programmatically "Create Query" for Access.
So when a user opens the MDB, there will be an entry in the "Queries" object.
Printable View
I was wondering if anyone could point me to resource that explains how to programmatically "Create Query" for Access.
So when a user opens the MDB, there will be an entry in the "Queries" object.
You can execute an SQL statement on your Access database by creating an OleDbCommand and calling its ExecuteNonQuery method. You need to execute a CREATE PROCEDURE statement. The Access documentation includes a Jet SQL Reference that includes information for that statement. You can also get information from MSDN or any SQL reference as it pretty much follows the standard for an SQL CREATE PROCEDURE statement.