Application role to access xp_cmdshell

From: Carl Olsson (caos_at_regerar.com)
Date: 02/17/04 

Date: 17 Feb 2004 04:39:43 -0800

I have an Access app linked to a SQL server db. This app uses
xp_cmdshell in some stored procedures and it works fine. As long as
the user is administrator... I'd like to set up an application role
that can execute xp_cmdshell and access my db but I don't know how to
do it as xp_cmdshell is in the Master db while everything else is in
my own db. I'm also unsure whether to call sp_setapprole from the sp's
or from the Access app.

Can somebody please give me some code examples or direct me to a good
site?

/Carl

Relevant Pages

  • handling errors from stored procs
    ... SQL Server 2000 ... comprise the call to a stored proc ... the stored proc gets run...if so, it would be nice if the Access app ... - when stored proc encounters error, it returns that error message ...
    (comp.databases.ms-access)
  • Re: How to avoid connection popup?
    ... >I have an access application with linked odbc tables to a "ms sql server ... > Everytime we start the access app and try to use it the connection dialog ... > done the access app workes fine until the next time we start it. ... you have SQL logins which correspond to Windows user accounts. ...
    (microsoft.public.access.externaldata)
  • Re: Migrating Access apps to Microsoft.NET...
    ... If I understand your question correctly, what this says is, once you have migrated your data to SQL server, you can move away from Access altogether - that is, for the front end also. ... For the latter, you can develop a new one using a .Net language such as VB.Net, for example. ... it actually requires you to re-make the front end from scratch, in an environment that is quite different to Access, and more time-consuming to develop in, with no re-usability from the existing Access app. ...
    (microsoft.public.access.conversion)
  • Re: Access DB to SQL Server
    ... back-end to SQL Server - but it depends on the complexity of the ... The result is that your Access app runs faster with a Jet back end, ... The biggest upsizing project I've done was a piece of cake. ...
    (microsoft.public.access.modulesdaovba)
  • LinkedTableManager Automation
    ... I have an Access app that uses SQl Server as the back end. ... I would like to do 4 things via VBA: ... Dim oConn As Connection ...
    (comp.databases.ms-access)