>I have an SPC inspection program. ISO guys are requiring that I lock the data so that it can't be edited after a certain point.
>
>How can I lock certain records in a table so that they can't be edited.
>
>It's in a database.
In addition to what others say, you can have a flag field in your table that gets updated according to your validation rules. Then the record editing can be disabled in your application, based on the value in the flag field. That will work whether table is in the database or not.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison