Restrict ability to open certon forms to administrator only

[Simon]

Hi All

First post on this news group but I bet some one can help.

All users running on office 2002 by DB is set at Access 2000 as we have a
few PC on the format windows 2000.

I need to lock some forms so they can only be opened by users with
administrator status as we have some problems with user changing data
records.

Any ideas?.




Regards

Simon Hardstaff

 

[Gerald Stanley]

The first place to research is the built-in workgroup
security features. These give you the ability to grant
access to the whole range of access objects to groups of
users.

Should you wish to include the security feature within your
own application, you could have a table containing the
userids of all users to whom you have granted
'Administrator privilieges'. Then in the Open event
handler of the 'secure' forms, check whether the
CurrentUser is on this table and, if not, cancel the Open
action with an appropriate message.

Hope This Helps
Gerald Stanley MCSD

 

[Kelvin]

Another option is to split your database into a front-end back-end. Then
just remove the forms from the front-end for the people you don't want to
give access to. This isn't a very secure method but it is quick and easy.
If all you need is to prevent accidental changes, this will work.

Kelvin

 

[Simon]

Nice one Gerald

I have workgroups setup & I now see what you are saying if only Microsoft
made things easy.

Thanks