Simply trying to avoid pulling down the database from the server every time I want to add a new query to the database. So, if there's a way I could code a page to add a query to the database, it would save me a lot of hassle. Most queries will be very simple (e.g., select * from ....). Upgrading to SQL server at this point isn't an option, unfortunately.
Save the queries a text into the database.<BR><BR>strSql = "select * from table"<BR><BR>Save the strSql in a varchar type column into the table. When you need to run it you can always get it from the database into the ASP.