insert with connection object puzzle

I have an database insert page that uses the connection object that has worked very reliably. Last week, however, a user claimed to have submited a record using my page but the data did not get inserted into the database. What might cause an sql insert command not to insert data?