By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,967 Members | 815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,967 IT Pros & Developers. It's quick & easy.

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

P: 21
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
Jan 31 '11 #1
Share this Question
Share on Google+
3 Replies


mshmyob
Expert 100+
P: 903
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,
Jan 31 '11 #2

P: 21
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
Feb 1 '11 #3

mshmyob
Expert 100+
P: 903
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,
Feb 1 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.