Convert now() Value to check sum

[Ice Rhino]

I have a textbox that contains a Now() date and time value which is saved into the table. I want to convert this field to a CheckSum. I know this is possible although I dont know how.

Also, I want a specific user to be able to enter the checksum value and be able to decode it to its original value.

Anybody got any ideas?

 

[Rich]

What's a CheckSum?

 

[pcs]

ice,

there are examples of check digit/encryption in the neatcd97 database.

don't think it's what you want as a date/time encrypts to another date/time, so the unencrypt would require a lengthy user entry. no way around this.

i suspect there is a simpler way to accomplish whatever it is your are trying to do...

hth,
al

 

[Ice Rhino]

pcs:- Yes there is a simpler way to do it. I was trying to over complicate things where all I actually needed to do was use user rights to prevent access to the underlying tables.

Therefore allowing the super user to have access to tables direct.

I thank you for your comments

All the Best

Toni