Question Access Security

[iceburg]

Is there any way of locking certain forms on a database so only certain users can gain access to them. Perhaps there is a way that only a administer can edit and perform alterations to the structure of the database whilest other users can only enter data.

Any help would be greatly appreciated.

Thanks.

 

[The_Doc_Man]

Search this forum for various subjects in security. For older versions of access, you can do this with workgroup security. Starting with (I think) Ac2k7, you need to roll your own on forms to evaluate who you are what what you are doing or are able to do.