I have an application that imports data from a text file to an ERP software. I use begintrans/ committrans so that if there are any errors during the import I don't have to worry about db corruption.

The import is executed by the user hitting an import button. When the import is running if matching data is not found in the db then a modal form appears allowing the user to select existing data or add the data to the db.

The user would like me to add an abort button somewhere so that if they hit the import button by mistake they can stop the process. I've thought about puttting it on the main form next to the import button but if they get as far as the modal forms then they wouldn't be able to access the abort button. Should I also put one on the modal form? Any better solutions?

What kind of code would I put in the abort click to make it stop the import process? Does there need to be some wait code in the import process testing to see if the abort has been clicked?

Thanks

Nichole