>i would like to know if there is a way to interrupt a scan or sql command with a command button while a progress bar is active

not from a button, but the user can press . You'll need a UDF to run on an OKL and have the SQL statement cancel. I have some code someplace that I can dig up if you need me to.

Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer