Duplicate records when sending SQL update statements

  • Thread starter Thread starter Nick
  • Start date Start date
N

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!
 
-----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
Click to expand...
one then access will not let duplicates be posted
 
Back
Top