I do not want someone to be able to go up to the Records menu and select "Delete All Records". How do I keep it from happening?

Thanks,

Bill

Take a look at the passwords and access privileges.

Hi Tom,

I know you can go and set things up through access privileges and I know you can un-click the Delete records. But I want them to be able to delete a record, I just don't want them to be able to Delete all Records and that I assume requires a calculation.

The All button has to be clicked and the Limited button selected. Then I would suppose a calculation is needed to disallow the "Delete All Records". I just don't know the calculation.

Bill

Do it in opposite direction. Forbid all menus and do the delete 1 record via script.

As Anatoli says, go to Passwords and uncheck the Delete Records checkbox. Then make a Delete Record script and put it in the scripts menu or assign it to a button.

Thanks guys,

I didn't even think of that! Sometimes the solution is so simple you miss it. You guys are great and I appreciate your snooping around the forum and giving such good advice.

Bill

I created a script to delete record and removed delete records from the password access menu. But it will not execute the script which is suppose to delete the record. The only way I can get the script to work is to have access to delete records. What am I doing wrong?

You can't just uncheck the