How to Disallow Change of TimeStamp Field

[Sedrick]

I am putting a timestamp field in a table, using Now() for the default value.

I'm using Access 97

Seems like I figured this out once before, but does anyone know of a way on the table level (not in the form) to disallow a user changing the timestamp? Is there a way to use a validation rule or another method to stop changes from being made to a field?

I know I can handle this in a form using the table, but would like to also be able to turn off changes at the table level.

I have one way of keeping the value from changing if it is the same for every record - just do a combo box lookup list and use "Limit to List". With a value that is different for every record though, that doesn't work too well.

Any ideas welcome. Thanks!

[twinnyfo]

Sedrick,

This issue is the best reason for not allowing users access to your tables.....

The only way I know is to hide the nav pane, and limit user access to forms.

[zmbd]

In V97 you will have to understand and implement the user level security model... make sure that when you do, that you create a new security workgroup... do not use the default...
I've bypassed many a security setup using a clean default workgroup. Also... I believe that in V97 we had to download the security manager... or maybe it wasn't installed by default. You can get this information by googling or searching Microsoft's archives.

Understand however, that any user that can open your database in V2007 or 2010 will be able to get around this; however, it'll be noticeable when you re-open the database.

What you may want to do is consider using a SHA type digest using the date and the data then you can validate the results... Rabbit has a very clearly written article in the insights tab of this forum about such a digest.

-z