Locking Access Tables

[KSC]

Hi,

Is there any way to lock the tables in access so that you can't add new
entries (in form view or in datasheet view) but that you can edit an existing
entry through either of those views?

Thanks!

 

[Roger Carlson]

Not in the tables themselves. However, you can provide your user with a
form which has the Allow Additions property set to No. This form can be in
either Form view, Continuous View, or Datasheet View.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L