Results 1 to 2 of 2

Thread: Programmatically Create Query

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Dec 2005
    Posts
    31

    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.

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    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.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width