Why is it that the Execute method does not produce a type-mismatch error as it should?
My problem was that I had a statement like this:
MyDB.Execute "UPDATE ... WHERE TextField = " & MyValue & " .."
VB/DAO/Jet did not give me an error, but also did not update my record.
Upon debugging, I fixed the statement as follows:
MyDB.Execute "UPDATE ... WHERE TextField = '" & MyValue & "' .."
And it worked fine.
But it would have been nice to have gotten a type-mismatch error initially, which would have saved me some debug time.