Delete SQL Query (Resolved)

why doesnt this work

i get a ADO error "Cannot delete from specified tables"

VB Code:

msgid = "A4523"
"DELETE * FROM messages WHERE MessageID = '" & msgid & "'"

the Internet user has the modify NTFS permission too :confused:

please help

I changed that permission to full and used a recordset too so it
was:

VB Code:

Set myconn = New ADODB.Connection
Set myrs = New ADODB.Recordset
myconn.Open connstr
 
Set myrs = myconn.Execute("DELETE * FROM messages WHERE MessageID = '" & msgid & "'")