|
-
Jan 4th, 2007, 08:22 PM
#1
Thread Starter
Junior Member
Programmatically Create Query
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.
-
Jan 4th, 2007, 10:29 PM
#2
Re: Programmatically Create Query
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|