Access 2000 form editing - updateable but not deleteable.

[Guest]

I have a form in access that needs to be updated by staff. I need the updates
to be un-deletable but 'Lock items' is not enough.

 

[Douglas J. Steele]

Forms have an AllowDeletions property that you can set to False.

 

[IanOxon via AccessMonster.com]

There are two easy methods to prevent records being deleted:

Method 1:
Set the forms AllowDeletions property to False.

Method 2:
Go to:
Tools > Security and click on Users and Group Permissions...
1. Find and select the object that is the form's RecordSource.
2. Select the Group representing the users you want to restrict dataset
access for.
3. Check:
a Read Design
b Read Data
c Update Data
d Insert Data
4. Uncheck
a Modify Design
b Administer
c Delete Data
5. Select the Users group and repeat steps 3 and 4.
6. Select the individual user accounts and uncheck all text boxes.
7. Make sure that none of the above group or user accounts have
administrative permissions for the database or ownership of RecordSource
objects or the database file.

Method 1 is the easiest, but will not stop users deleting records if they
have access to RecordSource object. Method 2 requires full implementation of
Jet Security, since users will open the database using the default Admin user.
Further information about Jet Security can be found in Access Help.

Regards

Ian