Re: Access link table security
From: Mary Chipman (mchip@nomail.please)
Date: 11/30/02
- Next message: Mary Chipman: "Re: Securing a web DB"
- Previous message: Erik: "invalid login packet(s) sent"
- In reply to: joe f. haydn: "Access link table security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Mary Chipman <mchip@nomail.please> Date: Sat, 30 Nov 2002 12:14:03 -0500
Since you're using Jet as a front-end and linking based on user
credentials, the best place to do this is to use VBA code on the
client. Create a form that prompts for user name and password if using
SQL logins, and use DAO to set the links (see the Connect property).
When the app closes, delete the links. This gets you around the
onerous chore of creating DSN's on each client. See
ConnectionStrings.com for dsn-less connection string styntax.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Tue, 26 Nov 2002 03:59:11 GMT, "joe f. haydn"
<JosephHaydn@earthlink.net> wrote:
>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.
>
>
- Next message: Mary Chipman: "Re: Securing a web DB"
- Previous message: Erik: "invalid login packet(s) sent"
- In reply to: joe f. haydn: "Access link table security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
