SQL to Delete records in an Access DB in VB6

[Caro]

I have set up a "DELETE * from xyz WHERE etc." but am not sure how to execute this in VB6 - I have tried database.execute and Refresh but niether of them seem to work
Any ideas? I haven't used a delete type sql before and I'm getting something wrong. The format of the Sql is OK as it works in Access. Thanks

[Lloyd]

I don't know if this is part of the trouble but FROM needs to be all in caps. Can you post part of your code that deals with this to give me a better idea?

Lloyd

[JHausmann]

"From" doesn't need to be in caps and, in fact, is an optional word.

Try removing the "*", it's not used in a delete.