Locking Records in Datasheet View

[JerSand]

A colleague (honest -- this is not the proverbial "a friend of mine&quot uses ACCESS 2000, but only the datasheet view. He and others enter data using the datasheet view and basically just store data that they export for analysis with other software. He has asked me how to lock entries when using this form of entry. I'm enough of a novice so that I don't know an analogue to the "Locked" property for forms, and I haven't had success by setting the default record locking box to "All Records."

Is this nonsense? Or is there something obvious (or not obvious) I've overlooked?

Thanks.

JerSand

 

[Terpsfan]

If you want to lock a field all you have to do is go into form design view, properties and then set Locked to True. This will work in datasheet view as well.

 

[Terpsfan]

If you want to lock entire records you would set Allow Edits, Allow Deletions and Allow Additions to false.

 

[JerSand]

Thanks for the responses, Omega36. I'm sorry to be so dopey about this , but . . .I can see all those properties in a form design view. However, these guys are working without a form -- just the datasheet view -- and when I display table properties, the display doesn't include the ones available in forms. Perhaps I'm missing something about the number and manipulation of table properties.

Thanks, again.

JerSand

 

[Terpsfan]

You don't do this in the table properties, but in the form design view properties.