Error("Could not delete from specified tables.")

  • Thread starter Thread starter Jay Balapa
  • Start date Start date
J

Jay Balapa

Hello,

Iam trying to delete a record in a access mdb file.

When I run AdoDb ExecuteNonQuery(), I get "Could not delete from specified
tables". Iam calling this from my aspx page.

What am I doing wrong?

Thanks.
Jay
 
Can you do it from Access?

You may have your keys set up to prevent deletes. If you
got that exception, you already have a connection and
all, so it's a db table issue. Pretty sure you are
trying to delete soemthing that has child records and you
don't allow such deletes at the DB level.

Try creating a dummy record and deleting it... If that
isn't the answer, let me know.

Good Luck,

Bill
 
Bill,

Thanks for your response.

Iam able to delete a record directly, but not through oledb/asp.net.

Jay
 
Back
Top