Custom SQL Script execution form

[NPUser]

I have to run a lot of Sql scripts against .mde database. I am trying to create a custom form to run raw sql script either to update, select or even insert simple values into tables. I was wondering if any one one out there already have a sample database that does this. I have attached the sample DB to show what am i trying to achieve?

thanks for your help in advance

 

[Uncle Gizmo]

Sorry , I don't know what your form does or doesn't do , I couldn't open it to look at the code behind it .

I saw a very nice example database a few years ago, (but I can't find it now!) It stored the SQL statements in a table so you could have multiple SQL statements that were easily maintained.

I mention this because that maybe one approach you could adopt if you are handling lots of SQL statements.

 

[NPUser]

Gizmo,
Thanks for the reply. I have DAO 3.6 Library reference in the database - may be that is causing trouble for you to open this database.

I have been doing a lot of "googling" to find the sample database - but no luck.