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
 
Back
Top