Results 1 to 1 of 1

Thread: Delete SQL Query (Resolved)

  1. Dec 26th, 2003, 02:44 PM #1
    señorbadger
    señorbadger is offline

    Thread Starter
    Addicted Member señorbadger's Avatar
    Join Date
    Oct 2003
    Location
    Mud pools of wellingborough
    Posts
    193

    Unhappy Delete SQL Query (Resolved)

    why doesnt this work

    i get a ADO error "Cannot delete from specified tables"
    VB Code:
    1. msgid = "A4523"

    2. "DELETE * FROM messages WHERE MessageID = '" & msgid & "'"

    the Internet user has the modify NTFS permission too

    please help

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

    VB Code:
    1. Set myconn = New ADODB.Connection

    2. Set myrs = New ADODB.Recordset

    3. myconn.Open connstr

    4.  
    5. Set myrs = myconn.Execute("DELETE * FROM messages WHERE MessageID = '" & msgid & "'")
    Last edited by señorbadger; Dec 26th, 2003 at 03:28 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width