ODBiC Discussion Board

Automatic record key

by Jongr, October 16, 2006 02:51

I am creating an application (using Access97 database) that needs the record key to be automatically assigned ('Autonumber' in Access)

However, I find that it is possible for a user to insert a new record and then 'backpage' Internet Explorer and be able to hit the update button again.

This results in the data being re-submitted and a duplicate record being created with the record being incremented by 1.

I would appreciate any suggestions on how to avoid this problem.



Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.