G
Guest
Greetings to all,
Does anybody here know of a utility that can be purchased to reset all
security for an entire Microsoft Access 2000 system?
We have a somewhat complex system that uses a single mdb (user interface) to
utilize around 78 mde's and 3 ade's via 18 mod's (mod = mdb dif name) all of
this front end runs off of 3 SQL Server 2000 databases with around 745
tables...
The problem is trying to figure out which groups can access which mde's etc...
Several people over the years have created several groups (total 88 groups)
It is easy to see what user is a member of what group. However, discovering
what
group has permissions to what database (Microsoft Access mde) is unavailable.
I would think that maybe somebody has seen a utility that can reset all of
the security for all mdb's (source code) in a given directory to a brand new
wrkgrp security file.
For instance: Say you came to a company where the only security file used to
create and govern an entire system (like the one here) was suddenly gone,
beyond repair etc...
There must be a utility somewhere that can reset all security on all
databases and all objects (forms, modules, etc...) within those databases
(once again referring to Access .mdb's)
So that the company could start from scratch with a brand new workgroup file
and then proceed to create an entirely new User / Group set up....
Any information you might have to help resolve a situation such as this
would be great.
Or if you had any knowledge of a way to findout what group has permissions
to do what with what object in what database from the security file that
would be great also... Thanks in advance! -- ~ SPARKER ~
Does anybody here know of a utility that can be purchased to reset all
security for an entire Microsoft Access 2000 system?
We have a somewhat complex system that uses a single mdb (user interface) to
utilize around 78 mde's and 3 ade's via 18 mod's (mod = mdb dif name) all of
this front end runs off of 3 SQL Server 2000 databases with around 745
tables...
The problem is trying to figure out which groups can access which mde's etc...
Several people over the years have created several groups (total 88 groups)
It is easy to see what user is a member of what group. However, discovering
what
group has permissions to what database (Microsoft Access mde) is unavailable.
I would think that maybe somebody has seen a utility that can reset all of
the security for all mdb's (source code) in a given directory to a brand new
wrkgrp security file.
For instance: Say you came to a company where the only security file used to
create and govern an entire system (like the one here) was suddenly gone,
beyond repair etc...
There must be a utility somewhere that can reset all security on all
databases and all objects (forms, modules, etc...) within those databases
(once again referring to Access .mdb's)
So that the company could start from scratch with a brand new workgroup file
and then proceed to create an entirely new User / Group set up....
Any information you might have to help resolve a situation such as this
would be great.
Or if you had any knowledge of a way to findout what group has permissions
to do what with what object in what database from the security file that
would be great also... Thanks in advance! -- ~ SPARKER ~