Application Role with linked Access tables

  • Thread starter Thread starter maswad
  • Start date Start date
M

maswad

Any idea how to setup connection for linked tables in Access 97 to log on
SQL server with application roles ?? is it possible at all?
 
maswad said:
Any idea how to setup connection for linked tables in Access 97 to log on
SQL server with application roles ?? is it possible at all?
Click to expand...

Unfortunately, you can't do this with linked tables. In an MDB, you would
need to access all your SQL tables programmatically to use the security
context of an application role. From an ADP, it's possible to partially
set an ADP connection to use an application role but there are a lot of
limitations. The following article I wrote discusses this in more detail:

How to Use Application Roles with Access Projects and SQL Server 2000
Desktop Edition
http://support.microsoft.com/default.aspx?scid=kb;en-us;308312

Let me know if I can clarify anything,

Brian M. Sockey
www.farsightsolutions.com
www.televantagenorthwest.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Log-in when Project Starts 1
dbo schema problem and permissions 1
ADP, Application Role, and objects 6
Access 2003 Project Security Setup 2
SQL Server Access 9
Security 2
Minimum SQL Server permissions needed 5
Application Roles 2

Back
Top