Access link table security

From: joe f. haydn (JosephHaydn@earthlink.net)
Date: 11/26/02 

From: "joe f. haydn" <JosephHaydn@earthlink.net>
Date: Tue, 26 Nov 2002 03:59:11 GMT

hello all. I've recently upsized an Access mdb with link tables going to the
SQL Server 2000.

I am now testing the security part for the Access frontend. All the Access
users are to be readonly. The testing environment is such that both Access
and SQL Server is on the same machine. (with SQL server in mixed mode) Of
course the Access apps will later be deployed at the client machines.

How and where do I set at the Access frontend so that I can choose the login
(and user) that holds a readonly permission? In other words where are the
places to configure the login name at the Access app?

Is it configured only at where ODBC DSN is defined? If so, when I wish to
change the login name for the Access frontend, do I need to play with ODBC
Manager?

Strange thing is that, while I know the link tables are connected to the SQL
server via ODBC (and thus DSN), when I remove the DSN entry in the ODBC
Manager, the connection still works...

I appreciate for any suggestion or comments.

Relevant Pages

  • Re: Access link table security
    ... onerous chore of creating DSN's on each client. ... >and SQL Server is on the same machine. ... >How and where do I set at the Access frontend so that I can choose the login ... >change the login name for the Access frontend, do I need to play with ODBC ...
    (microsoft.public.sqlserver.security)
  • Re: Connecting Access MDBs to SQL databases
    ... >> In Control Panel you set up a DSN that points to the SQL Server ... Never tried the IN clause against ODBC. ... ISeries box and I have never been able to get DSNLess to work against those. ...
    (comp.databases.ms-access)
  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Set up an ODBC connection Programmatically?
    ... HOWTO: Programmatically Create a DSN for SQL Server with VB ... Other people can use this database, connect via ODBC, ...
    (microsoft.public.access.modulesdaovba)