Access 97 and User-Level Permissions

[David Dubroff of Mr. PC]

Hello...

One of my clients needs to reset security permissions for several MDB files.

My client ran the user-level security wizard within several MDB files while
she was using a stand-alone installation of Access 97.

Now, the client has a network with several computers, and they would like
have multiple computers share some of the databases, using one workgroup
file for all of the users.

Is there an easy way to reset some of the older database files, in order to
have all permissions available from one workgroup file, as if the user-level
security wizard was never used?

Please advise...

Dave

 

[Peter Russell]

Hello...

One of my clients needs to reset security permissions for several MDB
files.

My client ran the user-level security wizard within several MDB files
while
she was using a stand-alone installation of Access 97.

Now, the client has a network with several computers, and they would
like
have multiple computers share some of the databases, using one workgroup
file for all of the users.

Is there an easy way to reset some of the older database files, in
order to
have all permissions available from one workgroup file, as if the
user-level
security wizard was never used?

Please advise...

Dave

I've never done this but I would guess that you can add all the users from
the various workgroups into one workgroup file and have everybody join
that file ( or nominate it in the shortcut).

The possible gotcha is that the users must be set up in EXACTLY the same
way they were set up in the current workgroups - same username and same
PID. But if you have this precise info then it ought to be OK.

Of course, you will have to allocate the added users to groups and for
each database make sure the correct permissions are assigned for each
group.

Regards

Peter Russell

 

[Jack MacDonald]

Further to Peter's reply, you should base all your permissions on
Groups, rather than on individual Users. That way, you only have to
add the users to the appropriate groups for them to gain access to the
database. As Peter points out, you must recreate the accounts properly
by using the same name and PID as was used to create them originally.