Application Roles

[D]

To anyone who can assist,
I'm still relatively new to access and I'm trying to wrap my mind around
implementing an application role. The idea behind this is that I'm hoping to
avoid having to create 1000's of user logins for access (select, update,
delete) to just 2 tables in my db. Needless to say, my search in finding
answers on the "how" peice isn't getting me very far. I found a website and
attempted even using the Northwind db test and it still didn't seem to work
(http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q308312). From what
I've read so far, using app roles in adp is quite the challenge. For what
I'm trying to accomplish, does this sound like something worth undertaking
and if so any leads on how I can get there?

 

[Aaron Kempf]

I think that u just need some ROLES

not application roles

build a windows user group.. add everyone you want access to that windows
group

give the windows group permission to the database


or better yet-- find the name of an existing group that meets your need and
then use the existing group


ask someone in network administration to help you

 

[D]

Thx for the advice, but someone tipped me off on using an ODBC data source.
This looks very promising, however, now I have a new issue in access. Even
though I'm clicking the save password option in access, I'm still getting
prompted for a password multiple times. It looks like it's trying to use
windows authentication first everytime it accesses a linked table. When I
uncheck the trusted connection and input the SQL login it works, it's just a
pain having to do this multiple times. I checked my ODBC config and it says
use server authentication. not sure what the problem is.