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

Help Securing Access Database

P: 2
Hi, I'm somewhat new to Access but have created a database that multiple people are using and I am now looking for a way to secure it.

I'm using Access 2007 and have a frontend and backend setup. However, I've had multiple issues with users accidently deleting records. How can I make it so I am the only person who can delete records? Or make it so records can only be deleted by accessing the backend directly?

Also, is there a solution for User Level Security in 2007?

Any help would be greatly appreciated. Thank you
Aug 2 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
Hi, I'm somewhat new to Access but have created a database that multiple people are using and I am now looking for a way to secure it.

I'm using Access 2007 and have a frontend and backend setup. However, I've had multiple issues with users accidently deleting records. How can I make it so I am the only person who can delete records? Or make it so records can only be deleted by accessing the backend directly?

Also, is there a solution for User Level Security in 2007?

Any help would be greatly appreciated. Thank you

MS has removed ULS from Access 2007. So in order to do what you're trying to do, you will have to not allow your users to view or get to the tables directly. If you've already taken care of that issue, then you simply need to set the AllowDeletions property of each form to NO.

J
Aug 5 '07 #2

Post your reply

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