Thanks for your help. Found most of the little niggles, and the sql did work in access. Now, when I try running the program, it does output the various correct results.
It seems that the quit does stop the processing, however, when you select q, it will give you the close message, however, it then gives you the final catch message,
Problem accessing the database java.sql.SQLException: Invalid handle
Not sure how to get it so it doesn't print that line, when quit is selected.
Probably something glaringly obvious, but it's been over a week and almost 8 hours a day, trying to sort it out, and I'm brain dead...
Thanks again for the assistance.
[ May 05, 2004: Message edited by: Sue Hunt ]