Duplicate records when sending SQL update statements

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!
 
L

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

replacing a link to a SQL Server table with VBA 1
Updating tables when you input new data 0
Query to duplicate a record with one field updated 0
Prevent Duplicate Form Entries 0
MS access login issue 3
Record(s) cannot be read; no read permission on 'MSysAccessStorage 1
selection in multiuser environment 3
Copy Record Problem 3

Top