Replacing Workgroup Security with Domain Groups/Acounts - is it possible

Hi,

I am new to this group, so forgive me if that was answered here previously.

Situation as follows:
We have Database with back end on SQL server and Front end as Access MDB
with workgroup security setup to restrict editing the forms etc
We have already setup Domain Groups to give permissions to SQL database and
folders where Front End DB resides.
But with workgroup security users must remember another set of username and
password, and it is hard to enforce 90 days password change policy.

So my question is:
Is it possible to do Workgroup type security, but assigned to Domain groups
not local to MDB set of Groups and Users.
So by putting Users to Domain group will give them all neccessary
permissions ?

Thanks in Advance


.

Relevant Pages

  • Re: Moving to MS SQL
    ... One additional major point is security: SQL Server can be much more ... Workgroup security was dropped by MSFT in version 2007, ... likely because the company realized it was never very secure. ... Availability also has other aspects, such as redundancy, database ...
    (microsoft.public.access.adp.sqlserver)
  • Re: sql server 2005 setup question
    ... For SQL Server Express, you only need to start the Instance, and perhaps the ... so I create domain groups for ... permissions in the database and assign the role to the domain group. ...
    (microsoft.public.sqlserver.setup)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)