lock records

[Guest]

can you lock records in a query or do I have to create a form to keep the
users from modifiying some records.

 

[Guest]

If you mean that you want to lock records all the time so that someone can't
alter or delete them, user level security is the only true option.

For the most part, users can alter or delete records in a form unless you go
to the form's properties and turn off Allow Edits and Allow Deletions. Still
this won't help much unless you stop users from getting into the tables
directly.

The is a trick to make queries unupdatable. If it's a single table query,
drag down the same table twice into the QBE grid. Then join the primary key
field between the two tables. This will prevent any changes to the table
through the query. If the from is based on the same query, it blocks the form
also. Still there's that direct access to the tables problem that only user
level security can fix.

 

[Guest]

Thank you, I will go ahead and create a form and turn off the allow edit on
the fields I don't want changed.