VBA Execute command not UPDATING record (no error reported)
Posted on 2006-05-26
In Access VBA, I execute an update query, and execute it as follows:
Dim strSQL as String
Dim db as Database
Set db = CurrentDb
strSQL = "UPDATE [...snip...]"
The update does not take place, but there is no error reported. The code has worked previously, but I have had to rebuild the backend database (another MDB) following a data corruption. I don't know if this is relevant.
The UPDATE string is valid: I created a new query, and pasted the code into the SQL view. It ran without a problem and updated the record correctly.
Windows XP Sp2