Protecting records after entered on data entry form

[Guest]

I have a mutiuser database for Access 97 that I want to protect a record once
it has been entered on a data entry form so it cannot be deleted. Some of
the field are protected for no data to be entered, but I need other fields on
the form to allow entry but no changes. I have checked through the on-line
help and some books but apparently am not looking in the right areas.
Any help is appreciated.

 

[Rick Brandt]

I have a mutiuser database for Access 97 that I want to protect a record once
it has been entered on a data entry form so it cannot be deleted. Some of
the field are protected for no data to be entered, but I need other fields on
the form to allow entry but no changes. I have checked through the on-line
help and some books but apparently am not looking in the right areas.
Any help is appreciated.

The form has a property named AllowDeletions. Set it to No.

 

[Joseph Meehan]

I have a mutiuser database for Access 97 that I want to protect a record
once it has been entered on a data entry form so it cannot be deleted.
Some of the field are protected for no data to be entered, but I need
other
fields on the form to allow entry but no changes. I have checked through
the on-line help and some books but apparently am not looking in the right
areas.
Any help is appreciated.

I have never used it that way, but User Level Security might work.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.

 

[Steve Huff]

There is a propety of the form "Allow Deletions" - the easiest thing to do
is set this to false.

-Steve Huff