Quote Originally Posted by XLGibbs
Since you are using Access to "house" the SQL statements, he is offering alternatives that are out there to potentially skip the process being in Access, but I am not sure you have those resources at your disposal (such as Visual Studio or another script writing software tool that allows programming in VB, Java or other non VBA language...
Access does not "house" the SQL statements, it "houses" the VBA that is used to pass the SQL string to the database. Access is really two products, the db back-end, and a forms front-end. The back-end understands SQL, but you don't need to run Access to use that aspect, you can do that from anywhere (as we all know with Excel).

If he has some tool to write ASP, then he has a tool to write VBScript. For goodness sake, it only needs a text editor, he isn't writing complex apps that would benefit from tools like Visual Studio.