Converting to Access 2013 and connect to both SQL Azure and SQL Server databases.
Understand MDW / workgroup security model abandoned but short of writing a new login script and checking each time an object is accessed, what is the best way to secure access to certain forms/tables/queries using SQL Server security.
In Access, I have extensibely used User assign to Groups and Access rights assigned to Groups. Thus users have access based on a combination of rights based on their roles.
All users login to SQL under a single account in my connection string. Any ideas to implement / convert my secured app to Access 2013?
It seems like this is something many people have to deal with.