Duplicate records when sending SQL update statements

[Nick]

I have written a Java servlet that allows users to input
information on a form and submit it for storage in an
Access 2000 Database. The servlet uses Java's JDBC-to-ODBC
bridge driver to connect through the ODBC to the database.
On occasion, when users update the information that is
stored in a specific table, there will be two duplicate
records in the table. I have been unable to solve this
problem. Has anyone else encountered this? Please help!

 

[Larry]

-----Original Message-----
I have written a Java servlet that allows users to input
information on a form and submit it for storage in an
Access 2000 Database. The servlet uses Java's JDBC-to- ODBC
bridge driver to connect through the ODBC to the database.
On occasion, when users update the information that is
stored in a specific table, there will be two duplicate
records in the table. I have been unable to solve this
problem. Has anyone else encountered this? Please help!
.
Check the primary key field in you database. If you have

one then access will not let duplicates be posted