> I would like to prevent duplicate entries from being
> inserted to a table (MS Access). Is there a way to do this
> without querying the database and comparing the
> "pre-inserted data" with data currently in the table?
Duplicate records normally occur when the user backtracks and refreshes the page that
inserted the record. If you CFLOCATION to another page after the insert, the user
won't
be able to backtrack.
Another way is to insert a blank record (using the next available
number) when the user accesses the form. Then when the form is saved you simply update
that record. The drawback is that blank records may be left in the db if the user
doesn't
complete the operation. Of course you could insert a date/time field with the blank
record and run a script to clean out blank records that are old.
Gene Kraybill
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
