[quote user="BrainSlugs83"]
zip -- Access allows for this syntax (DELETE * FROM tbl_x) and it works (but as expected, it does not remove the table, just all rows)
Jeff is completely right on.
[/quote]
"DELETE * FROM tbl_x" only works as expected if it results in an SQL syntax error.
Does "DELETE column1, column2, column3 FROM tbl_x" work too? What does it do?
But hey, maybe "DELETE * FROM" is an Access extension to the SQL language. All the other backends I have access to might just be more standard-compliant. I know the only way anyone would remove my favorite SQL extensions would be over my cold, dead fingers (mmmm...table joins in DELETE queries...). ;-)