I have an Access database that I need to modify using SQL commands. I want to update a row in the Settings table, but my SQL command isn't working:
UPDATE Settings SET Value='test' WHERE Name='LastRetrievalTime';
I can retrieve data just fine using this SELECT command though:
SELECT Value FROM Settings WHERE Name='LastRetrievalTime';
Can someone tell me what is wrong with my UPDATE command?
Thanks in advance.