Locking out MS Access Users...

From: rich (rich_at_discussions.microsoft.com)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 07:53:02 -0800

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? I know using SQL Server
application roles (especially for web applications) is BAD!

Thanks!
-rich

Relevant Pages

  • Sending users to sql server
    ... they transfare the database to sql server and use it as SA. ... Now i would like to transfare the access users on the workgroup to sql ...
    (microsoft.public.access.security)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)