Allow Deletions Isn't Working

K

Keith

I have a form (Access 2007) on which I've set the Allow Deletions Property to
No. For some reason though, my users are still able to go to Edit-Delete
Record and are able to delete the record. Is there some other setting that
needs to be in place in order to prevent deletions?

Thanks,

Keith
 
K

Keith

The form I am describing is not a subform...it is the main form.

Although I am designing in Access 2007, I am still saving as an Access 2000
mdb in order to accommodate users running older versions of Office. Could
this have something to do with it?

Thanks,

Keith
 
K

Keith

I'm replying to my own post (talking to myself?) because I figured out what
was wrong. The macro opening the form was overriding the Allow Deletions
setting. I created a new button opening the form using the wizard and
modified the code to do what I wanted, and the Allow Deletions:No stuck. I
hope this is helpful to someone in the future.

Thanks,

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top