Simple DELETE * doesn't

Question

Simple DELETE * doesn't

Peter N Roth 1

I’m forgetting something obvious, but I’ve tried
CurrentDb.Execute “DELETE Table1.* FROM Table1;”, dbFailOnError
Tried it with a querydef and DoCmd.RunSQL but the records just won’t go away ….
What am I missing?

DaisyTian-1203 11,651 Reputation points Moderator

2021-01-05T07:01:33.56+00:00

@Peter N Roth
If you want to delete a data from table with condition，please try Delete from Table1 where Table1.Column= *** . If I misundestand your question, please point out and give me more details.

1 answer

Your answer

DaisyTian-1203 11,651 Reputation points Moderator

2021-01-05T07:01:33.56+00:00

@Peter N Roth
If you want to delete a data from table with condition，please try Delete from Table1 where Table1.Column= *** . If I misundestand your question, please point out and give me more details.

Answer 1

Viorel 127K

Try “DELETE FROM Table1”.

0 comments

Share via

Simple DELETE * doesn't

1 answer

Your answer