Ha! beat you to it! I am answering my own problem, after a week of intense frustration, I desperately plugged in a conn.close() statement and it now works. I had left it up to the java cleanup crew, and they didn't do the job!JJ

Hi guys, this problem makes no sense. This code compiles, runs with no errors, returns that 1 record was updated, yet the database remains unchanged. No setxxx commands work. Autocommit is on. The database is Access 2002, and wonder if that might be a problem. Can anyone else run this or similar simple setxxx using access database? Database is...