Locking Table's permanently, with updates via forms.

[warezm]

How can I create a table that can only be written to with a form, and whose records are permanently locked - nonchangeable even by the admin user?

I want to create audit logs using this method.

 

[Junior1544]

Well, i guess you could dis-allow any modifications using the user level security... go into the security area where you control security for all objects, and stop all modifications from there... but take note!

CAUTION!

Once you do this you will not be able to modify any data, or the structure... so if you want to make more fields checked, you will need to recreate the table...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[warezm]

Thanks for the info.

But I am not sure what you mean. I go into the database as a member of the admin group and change the permissions on the object, but if i restart the program, then I can just change the permissions for the oject (table) back to full.


Please clarify what method you are using.

Thanks again.