By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,830 Members | 2,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,830 IT Pros & Developers. It's quick & easy.

How to Disallow Change of TimeStamp Field

P: 43
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!
Sep 7 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 3,283

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.
Sep 7 '12 #2

Expert Mod 5K+
P: 5,397
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.

Sep 7 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.