securing large databases

[vanessa]

hi we have a large database with near 200,000 items listed - we have just
upgraded to access 2003 - we have serveral staff using the same database, all
the staff need to be able to add, deleate and look up items - but how can i
make it so when they alter (sometimes an item has typing accidentaly removed)
or deleate an existing item a pop up box appears asking them if they are sure
before continuing? ideally one they just click yes or no to

 

[Pat Hartman]

You would put the confirmation message in the FORM's BeforeUpdate event.
If MsgBox("do you want to save?", vbYesNo) = vbNo Then
Cancel = True
Me.Undo
End if