J
Joelle921
I am charged with securing 100+ dbs which are used by 100+ users - most
dbs are reporting only and don't require any user data-entry so they
can be ReadOnly.
Currently all users default to Admin and don't use (or want to use)
ids/passwords to signon. What I'd like to do is limit the security for
Admin and setup a new group - SuperUser - which would then have
unlimited security to all dbs. So only if I (or another administrator)
logs on a SuperUser will the db allow full authority.Is this possible??
Is there any other way to limit security to all other users without
forcing them to sign on each time??
Can I create a group EndUser and force the id/password thru each time
they click to open a db from the front-end menu - ie in the Shell
statement - tho there would be an issue if they open the db anyway
other than thru the menu - they'd have to manually enter the
id/password
Can all users have the same id/password so I dont' have to manage 100+
PS - I'm currently forcing the db open as ReadOnly thru the menu but if
they dont' use the front-end menu it opens with Full-access and the
powers-that-be aren't satisfied
Call Shell("""C:\program files\microsoft office\office11\msaccess.exe""
\\accpost\agreements\agrmnt.mdb /ro", 1)
thanks
dbs are reporting only and don't require any user data-entry so they
can be ReadOnly.
Currently all users default to Admin and don't use (or want to use)
ids/passwords to signon. What I'd like to do is limit the security for
Admin and setup a new group - SuperUser - which would then have
unlimited security to all dbs. So only if I (or another administrator)
logs on a SuperUser will the db allow full authority.Is this possible??
Is there any other way to limit security to all other users without
forcing them to sign on each time??
Can I create a group EndUser and force the id/password thru each time
they click to open a db from the front-end menu - ie in the Shell
statement - tho there would be an issue if they open the db anyway
other than thru the menu - they'd have to manually enter the
id/password
Can all users have the same id/password so I dont' have to manage 100+
PS - I'm currently forcing the db open as ReadOnly thru the menu but if
they dont' use the front-end menu it opens with Full-access and the
powers-that-be aren't satisfied
Call Shell("""C:\program files\microsoft office\office11\msaccess.exe""
\\accpost\agreements\agrmnt.mdb /ro", 1)
thanks