Help Securing Access Database

[gwise]

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

[JConsulting]

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