Help with a delete statement

[bjgarner241692]

This is not a PHP issue, it is ASP with Access and it has nothing at all to do with WA products, but I'm hopeful that someone can help.

Why does this work?
WADAcounter_cmd.CommandText = "SELECT * FROM viewcounter WHERE extra1 Like '%+http://%'"


But not this?
WADAcounter_cmd.CommandText = "DELETE * FROM viewcounter WHERE extra1 Like '%+http://%'"

I've tried * instead of % because if you were to run it in ACCESS you would use *.

[bjgarner241692]

Yay - just a little more googling.

Query was fine. DB needed to be compacted and repaired as I had just removed about 20000 records prior to this.

Hope it helps someone else some day.