Access Hangs on "Delete *" from linked table

I have a table called TKSD0UJA in my sqlserver that access links to.
The codes is:
strSel = "DELETE * FROM [TKSD0UJA];"
db.Execute strSel
it hands on db.Execute. I checked permissions within the sql server and
I have delete permission. Is there any reason why it should hang?Ari
Are you sure you don't need WHERE clause in the query?
How much does data exist in the table?
"Ari" <Kooshesh@.gmail.com> wrote in message
news:1130938827.948678.159380@.g44g2000cwa.googlegroups.com...
>I have a table called TKSD0UJA in my sqlserver that access links to.
> The codes is:
> strSel = "DELETE * FROM [TKSD0UJA];"
> db.Execute strSel
> it hands on db.Execute. I checked permissions within the sql server and
> I have delete permission. Is there any reason why it should hang?
>|||> The codes is:
> strSel = "DELETE * FROM [TKSD0UJA];"
You don't delete columns, you delete rows. So, the syntax "DELETE * FROM"
makes no sense. Try DELETE FROM tablename or DELETE tablename.
A|||much thanks