2. ASPRunnerPro General questions
  3. Could not delete from specified tables
This topic is locked

Could not delete from specified tables

 		12/18/2003 9:03:01 PM
ASPRunnerPro General questions
author

I don't understand why I cannot delete a record. This is the error that is thrown:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.
They do delete when you click on them from Access. I can add and edit in the ASP pages.
THanks

Bandit
Sergey Kornilov admin 12/19/2003

Bandit,
here is what you can try to do:

  1. In include/..._variables.asp chnage vDebug variable from False to True.
  2. Try to delete record and copy SQL statement displayed on the of ASP page.
  3. Paste this statement into MS Access new query and try to execute it there.
  4. Post results here.
    Best regards,

    Sergey Kornilov
500081 12/22/2003

It didn't like me trying to delete from the query directly. It threw the same error in Access. I changed the code to delete the record directly from the table and that works fine.
'changed from deleting from query based upon table to the table directly

'strSQL="delete from " & strTableName &

strSQL="delete from tblPfaltzReport " &
If you have a beeter method please let me know.
Thanks,

Bandit