>Using VB.net, I can now update using an oledbcommand with an oledbconnection, but not using the oledbdatadapter.update method.

Well, what is the UpdateCommand of the adapter? Since the Update method really just calls an OleDbCommand object, you should be able to set the OleDbAdapter to hold the OleDbCommand that works for you.