Wrong query?

[Andrew R.]

This query works fine with MS Access db, but gives me error with SQL Server 7.
'
"DELETE * FROM tbMyTable"
'
I try to delete all records from the table.
Why it doesn't work with SQL Server?

[nilch]

In Sql Server just give
"Delete from <tablename>"
instead of "delete * ...."

I guess that is the difference.