[First EE question here - so hoping the below is clear enough]
Wondered why no update was happening from a rather simple update statement in my variable: vMySQL.
Printed out the contents of vMySQL and applied the same update statement directly to the database - and it worked perfectly, so there is nothing wrong with the statement
Found the error using the below.
db.Execute vMySQL, dbSeeChanges + dbFailOnError
Have tried repair database, turning pc off and on, various lock settings in "Tools>>Options>>Advanced Tab", putting DBEngine.Idle dbFreeLocks just before the execute statement but nothing changes. Always get this error.
Any ideas from anyone? Any help would be much appreciated