UPDATE SQL query using WHERE and a date/time data type... Multiple changes...

[Yamaeda]

UPDATE IshaKriya11Apr12 SET Status = 'Check' WHERE Num = 100

The field name status might cause some problems if it's also a reserved word (i'm not quite sure about that). Check ought to be a text field, thus apostrophes are needed. Assuming Num is a numeric field you dont need '' there.

Try the query directly in the DB through e.g. sql management server. 

/Y