MS Access query returns many rows in preview but 0 on run (execute)

[mark.cockburn]

When i run the following query on my table it returns 0 rows but when i
run it in the preview mode (where the update is applied) more then 2000
records are returned.

UPDATE dbo_ISRTEST SET dbo_ISRTEST.Product = "Gure"
WHERE (((dbo_ISRTEST.Product) Like '%station%'));

If I change the Like to be just = as below then everything works so it
seems to be something about the Like statement.

UPDATE dbo_ISRTEST SET dbo_ISRTEST.Product = "Gure"
WHERE (((dbo_ISRTEST.Product)="station"));

Unfortunately i need to use like as Product field is a text field and
station is just a tag which may appear in it.

Any help would be greately appreciated.

Funny thing is that stuff used to work but for some reason doesn't
anymore.

I am connecting to a SQL database through ODBC & a linked table.

[Terry Kreft]

Replace % with *


--

Terry Kreft
<ma***********@honeywell.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

When i run the following query on my table it returns 0 rows but when i
run it in the preview mode (where the update is applied) more then 2000
records are returned.

UPDATE dbo_ISRTEST SET dbo_ISRTEST.Product = "Gure"
WHERE (((dbo_ISRTEST.Product) Like '%station%'));

If I change the Like to be just = as below then everything works so it
seems to be something about the Like statement.

UPDATE dbo_ISRTEST SET dbo_ISRTEST.Product = "Gure"
WHERE (((dbo_ISRTEST.Product)="station"));

Unfortunately i need to use like as Product field is a text field and
station is just a tag which may appear in it.

Any help would be greately appreciated.

Funny thing is that stuff used to work but for some reason doesn't
anymore.

I am connecting to a SQL database through ODBC & a linked table.