Using SQL Server Application Roles with Access 97

[agc1976]

I was suggested tu use Application Roles for the security of my SQL/Access97 App.

Is this possible? Where can I find information on how to implement this type of security with these 2 tools?

Thanks

 

[AmiDenise]

The following KB article details how to create application roles on sql server.

http://support.microsoft.com/suppor...on Roles&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=SQL

Should you have any further questions, you may want to search the Microsoft Knowledge Base located at:

http://search.support.microsoft.com

Good luck!
Ami