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

Question posted by: mark.cockburn@honeywell.com (Guest) on July 13th, 2006 08:55 AM

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.

Quote | Subscribe