lock records?

[Zorro1265]

Is there a way to lock records at the table level? I have a database that stores reports which once generated should never be altered. I lock down the records via my forms but can I lock the table so no one can change data from the guts of the database?

 

[hennep]

I think user level security is the best option. by default users log in with the admin account, so admin cannot change records in this particular table. Create an other user to maintain this table. You could do this in an other form or enter records by opening an other workspace in code