January 13th, 2004, 03:46 PM
Package a sql query for end user access
I need to know if it is possible to package a SQL query so that the end users can run it without having to enter the username/password for sql or have access to any ither functions within SQL. BAsically I just need to allow the users access to the db to runone specific function and see the output from running that query.
January 13th, 2004, 11:36 PM
How do you plan on delivery this to the end user? Graphical? Web? Via Access? Excel? You can create a VB routine or VBA macro or an ASP front end or a *.dqy Query. There are numerous options available to accomplish this task.
January 14th, 2004, 09:16 AM
I am not sure, whatever is easiest, I am not a programmer so I was hoping for a 3rd party app.