I am using a MS Access 2010 DB that was upgraded from MS Access 2007.
When I run a simple UPDATE query (e.g. as follows) that works fine in MS Access 2007 version, I get the pop-up error message "Invalid Argument".
UPDATE [Store List] SET [Store List].Manager = "John" WHERE ((([Store List].Manager)="Mike"));
Another weird phenomenon is: when I manually change some values using copy-paste upon the table, the error "Invalid Argument" pops up too; if I ignore it and continue pasting the new values, the update can be done.
How to deal with this issue?
Thanks in advance.