I have a VB 6 program where that works against a ACCESS 2000 DB with the ADO-objekts.

In some places it "runs" SQL Update questions like:

UPDATE Table SET Field = 'something' WHERE ID = ...

and so on, always with a WHERE and with the Execute-method of the connectionobjekt.

But sometimes (not often) its like the WHERE wasn't there in the SQL-string and all records in the table are updated.

Very strange, I'm thinking if it can happen if the database never is repaired and the indexes get "crazy" or something, have anyone experienced this and did you then find any answer why it happened???