#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    21
    Rep Power
    0

    Question 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.

    Thank you
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    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.
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    21
    Rep Power
    0

    not sure


    I am not sure, whatever is easiest, I am not a programmer so I was hoping for a 3rd party app.

IMN logo majestic logo threadwatch logo seochat tools logo