Search results

The whole point is that I want to use a prepared statement so that it can be repeated. In MySql you can pass a zero or a null value into an auto-increment column and the next number in the sequence is used. How do I do something similar in Access?

I have a table with 9 fields the first being an autonumber data type. If I use a prepared statement to insert a row how do I get around the fact that I don't need to give a value for the first column? If I use a placeholder (?) then I need to give a value for it. Here is my code: String query =...