MS Access Connection Strings

There are two common connection string types that can be used to connect to an MS Access database.

One of them:

Driver={Microsoft Access Driver (*.mdb)};DBQ=Database.mdb

The other one:

PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=Database.mdb

Normally I haven't had a problem using both of these, but I experience the first one to be better. When running UPDATE queries against the second one (PROVIDER) I got the error code -2147217900 with the message "Syntax error in UPDATE statement. Microsoft JET Database Engine." when there were NO syntax errors what-so-ever. I even tried the query directly in MS Access with success. All permissions were OK as well and easy to handle.

Once I swapped to the "Driver" connection string, it worked perfectly.

I find this information very useful, especially since there are no indicative or direct logics behind this issue.