Security for an ADP; what is Access part? What is SQL server's part.

[computer.mike]

I have an ADP (Access forms, etc with SQL Server backend)

How would I implement security for end users? Do I set up in Access?
Then how does access talk to SQL Server? Do I set up user accounts in
SQL Server? To I configure both? Isn't their an application role in
SQL Server?

I need a general framework to start with. Any advice or links would
be appreciated.

Mike

 

[Arvin Meyer [MVP]]

I generally use integrated Windows security with SQL-Server, then create an
Access ADE (or more often an MDE) for the Access Front-end. You don't need
to login, but you do need to be in a group with permissions to access
SQL-Server.