Results 1 to 2 of 2

Thread: Store and Execute Sql in MS Access Table

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2006
    Posts
    1

    Store and Execute Sql in MS Access Table

    Please refer to attached Sql2.txt and MyCoding1.txt before reading below.

    My problem is that it will be quite slow when there is a lots of record as i have to loop through all records of tblC and then insert it into flexgrid.

    What i have in mind is only 1 Sql command to display the output:

    MyRst1.Open MySQL1
    Set FlexGrid1.DataSource = MyRst1
    FlexGrid1.Refresh

    izzit possible?
    Attached Files Attached Files

  2. #2
    PowerPoster
    Join Date
    Apr 2005
    Location
    Debug.Print
    Posts
    3,885

    Re: Store and Execute Sql in MS Access Table

    you might want to search the forum for "stored procedures" which has been discussed many times.

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