Blocking MS Access from linking tables...

From: Matthew Wells (MWells_at_FirstByte.net)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 13:54:05 GMT

Good morning...

I have an Access front end that uses SQL Server linked tables. SQL Server
uses Windows authentication. I have one Windows group that all Access users
are a member of. I added that group to SQL Server logins and gave it
public, datareader, and datawriter rights to the one database that's used.
My front end is locked down, but I want to stop users from creating a new
.mdb and linking SQL Server tables through DSNs or ADO connections or even
just importing the links from the actual front end.. I've tried setting the
"denydatareader" security policy - that keeps the SQL tables from being seen
in the import/link list- but also blocks read rights from the actual front
end database. I could set an Access database password on the front end to
block importing the links, but that only solves one of the three problems
and I want to stay away from Access security altogether.

Is there a way to stop users from creating their own DSNs or connection
objects or linking tables while still using Windows authentication?

Thanks.

Matthew Wells
MWells@FirstByte.net

Relevant Pages

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Blocking MS Access from linking tables...
    ... I have an Access front end that uses SQL Server linked tables. ... I have one Windows group that all Access users ... just importing the links from the actual front end.. ... objects or linking tables while still using Windows authentication? ...
    (microsoft.public.sqlserver.server)
  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... database to backend and then link all table from front Access database to ... we never allowed user can login to sql server to do any thing, ... Each user they required Windows Authentication when they open they won ... install the sql server. ...
    (microsoft.public.sqlserver.security)