access sql

[oaishm]

I have access fronting ms sql express and tried to make a query thing like:

update table set table.field1 = 0, table.field2 = 0 where table.field3 like "%some text%"

it updated 0 records even though selecting with that where clause turned up 355 records.

If I update with something like where field4 = 0, it updates with the right number of records.

 

[Norie]

The wildcards in Access are * not the % that are used in SQL Server, which is what I assume you are using as the backend.