How to prevent access to certain forms in ms access database 2007?

[damola]

Good day everyone
Please how can i prevent access to certain forms in ms access database 2007.
i want it to be in such a way that when i enter user login,it automatically detects the forms the user has access to and the ones the user doesn't have access to it will say access denied
thanks for your help

[mshmyob]

Access 2007 no longer has user level security built in. If you wish security you either have to implement a SharePoint server or create your own code to deny/allow application functionality.

cheers,

[damola]

Thanks for your reply
Am new to access, How will i use share point or which vba code will i use
The database is split into front and back end
thanks for your help

[mshmyob]

This is not the forum to discuss SharePoint but I would suggest you talk to your SharePoint specialist in your organization about security with SharePoint and AC2007.

As for the vba code we can help with specific problems but you would have to attempt it yourself first. You need to determine the process you want to use for security - how you want to secure, what you want secured, who you want it secured from, etc..

If you have specific problems we will be happy to help.

cheers,