I'm using the standard jdbc-odbc driver for a local
Java program to manipulate an MSAccess database. I've set up the connections correctly and I can query information from the DB with no problems. I can also create tables through
jdbc with no problems. But whenever I try to INSERT data into a table, the data
never actually gets there. JDBC never returns an error, however, and the code runs just fine.
I'm baffled. The Access table is called '
test', and there is only one column called 'name' of type 'Text'. I've found that it doesn't matter whether there's a primary key or not, or what type of column I use, or whether it's auto-numbered or not. Here's the piece of code that's killing me:
I've also tried it with a standard Statement with no luck. Any help please?