I have written a survey in ASP using javascript and the answers are dumped into an MS Access 2000 database. Whenever I press the submit button on the form, 2 almost duplicate records are recorded to the database. The only reason they are not duplicates is because I have an autonumber field as PK. So each individual record has a unique number, but all the data fields are the same in each record. Does anyone know why this is happening and/or how to fix it? My connection string:
Code:
conn= Server.CreateObject("ADODB.Connection")
conn.Open(Application("CONN_STR")="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=//server/folder/folder/db.mdb")
mysql = "sql statement";
conn.Execute(mysql);
conn.Close();