ASP Database error trapping
Hi all. I've created a little web app that will take CSV files of certificate nominations, enter them into a database ready for printing out by the office. Now it all works, the only problem is that if the person entering the data can't spell their subject correctly or can't remember what year tutor groups are in or even spell them right (no bitterness at all I'm sure you can notice) of course the page will throw up an ADO error and stop importing, leaving some of the entered lines there but not all.
I have a rough idea how to trap errors, I have a rough idea on how to show teh error and give them a clue about what they have done wrong. My poor little brain can not seem to work out if using an Access DB will an ASP page be able to either roll back the DB or stop the data being entered if an error is generated?
I think it isn't possible as Access doesn't do roll backs and as the error is generated as teh data is being entered you can't stop the previously entered data being there. But confirmation or other ideas are always welcome.