Access 97 permissions

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

Hi,
I would like to restrict all the permissions on a data
base to viewing only except for the Administrator. I have
been able to set a user level password box for the
administrator upon opening the DB. But I can't figure out
to have the table open without the user being able to
change any data, but just view it. HELP!!!
 
-----Original Message-----
Hi,
I would like to restrict all the permissions on a data
base to viewing only except for the Administrator. I have
been able to set a user level password box for the
administrator upon opening the DB. But I can't figure out
to have the table open without the user being able to
change any data, but just view it. HELP!!!
.
Yes, go into the securities and assign user account
Click to expand...
read only permissions. Caution this will also require to
the user group also. If you want to really get elaborate
you could make up a switchboard (main) and go into the
propertie settings for read only on every thing in the
database if you wish. You could also do this with a Macro.
Many ways to achieve these. What ever you do, make sure
you password out the Admin account and remove the
permissions for the group. Now make sure the permissions
are for you. Also on the options tab, set for user not
owners on the run permission. This will also require a log
on procedure and a password. Remember to write all this
down and please keep it in a very safe place. Once you
loose this, you will not be able to rebuild your work
group account. Now you have no way to open this database /
unless you keep a back up of your work group file
(recommended). Never know when this could be damaged.

Ricky J. Pyzynski
Data Bases ETC
 
read only permissions. Caution this will also require to
the user group also. If you want to really get elaborate
you could make up a switchboard (main) and go into the
propertie settings for read only on every thing in the
database if you wish. You could also do this with a Macro.
Many ways to achieve these. What ever you do, make sure
you password out the Admin account and remove the
permissions for the group. Now make sure the permissions
are for you. Also on the options tab, set for user not
owners on the run permission. This will also require a log
on procedure and a password. Remember to write all this
down and please keep it in a very safe place. Once you
loose this, you will not be able to rebuild your work
group account.

Now you have no way to open this database /
unless you keep a back up of your work group file
(recommended). Never know when this could be damaged.
Click to expand...

Except for one small thing. All of the objects in his database will still be
owned by the Admin user. So the Admin user of *any* workgroup file, can
regain whatever permissions they want, at any time, without having *any*
access to the original workgroup file, at all.

I think the original poster would be well advised to read the Access
Security FAQ, or some other equivaent document, to learn about Access
security!

HTH,
TC
 
Back
Top