I'm struggling with inserting a record to Access 97 database.
The
java program should insert one record into a table in a Access database which is allowed to read and write. I set up ODBC in the control panel->Data Sources(ODBC). The program seems working. However, it doesn't insert the record into that table. Strangely, when I use the same program, just change DSN to another database, it works fine. I just cannot think a reason which might cause the problem.
many thanks,
wendy
[ Edited by Dave to format code and remove smilies ]
[ December 09, 2002: Message edited by: David O'Meara ]