jdgwebdev
03-19-2013, 10:18 AM
Hello all,
I've searched and dug around and found several guides saying the same thing. yet I'm having problems and need help!
The situation is simple, I've got a few dozen rows that all have an issue with 1 column. Data was entered as "1" instead of "001" so I'd like to simply update the data accordingly.
UPDATE tblSales SET strSalesCodeID = "001"
WHERE strSalesCodeID = "1";
("001" and "1" are strings not integers
When I run this, Access says "Operation must use an updateable query"
Why, and how do I fix this? Thanks!
I've searched and dug around and found several guides saying the same thing. yet I'm having problems and need help!
The situation is simple, I've got a few dozen rows that all have an issue with 1 column. Data was entered as "1" instead of "001" so I'd like to simply update the data accordingly.
UPDATE tblSales SET strSalesCodeID = "001"
WHERE strSalesCodeID = "1";
("001" and "1" are strings not integers
When I run this, Access says "Operation must use an updateable query"
Why, and how do I fix this? Thanks!