Re: Locking out MS Access Users...

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 14:08:20 -0500

"rich" <rich@discussions.microsoft.com> wrote in message
news:14E83BBA-95CC-4221-8634-9B1821BAF19D@microsoft.com...
> I have an ASP.NET web application that uses a SQL Server 2000 database. I
am
> forced to use Impersonation/Delegation with Windows accounts so that we
can
> audit activity at the database level. However, everyone in the
organization
> also has MS Access on their desktop. How can I prevent MS Access users
from
> creating a new .adp and executing any of the stored procedures created
> specifically and solely for the web application?

While you cannot prevent them creating a new ADP, how (or why) do the Access
users have access to store procedures that would access the SQL Server 2000
db?

Steve

Relevant Pages

  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... Coming back to the original VPN discussion... ... Would you consider using an ADP talking across an fast broadbank link to ... local database, but ideally we would like to centralise. ... Would SQL Server replication be an option, ...
    (microsoft.public.access.adp.sqlserver)
  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... you're careful about your database design, though, that may be the way to ... As a result of the difficulties I've had, I try to avoid SQL Server ... Would you consider using an ADP talking across an fast broadbank link to ... A thin client interface has been suggested, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Recordsource only available to Administrator on clients
    ... In the ADP itself, when a connection is established under a non- ... Administrator Windows logon, all stored procedures, for example, are ... It seems that SQL Server should be designed to ...
    (microsoft.public.access.adp.sqlserver)
  • RE: SQL Server 2000 & Access 2007 Project
    ... You have indicated that the Access database is an Access Project file (ADP) ... occurs when we attempt to open the same table's design view in the Access ... so that SQL server cannot get the type of the data in the design view. ...
    (microsoft.public.sqlserver.clients)