2. ASPRunnerPro General questions
  3. Delete Error
This topic is locked

Delete Error

 		7/20/2005 12:03:33 PM
ASPRunnerPro General questions
C
 chuckbragg author

I am having a problem with being able to delete entries in my data base. I keep getting the following error:
ASP error happened
Technical information

Error number -2147467259

Error description [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.

URL /ASPRunnerPro/OrderDetailsQuery_list.asp

SQL query delete from [OrderDetailsQuery] where [OrderDetailID]=291
I have check the forum and have tried all the known fixes including the following:
1.)Checked permissions on asp files and database file.

2.)Have allowed Parent paths (since it is running on Server 2003 IIS 6.0)

3.)I am able to add and edit but delete just errors out with about message.

4.)I have also noticed that the delete button doesn't show up at all on Mac's

5.)OrderDetailID is a key field and doesn't allow duplicates.

6.)
Any help would be appreciated
-Chuck
P.S. I noticed a post regarding using check buttons in the list.asp to allow updating multiple check boxes only. Is there any idea when this may be implemented, this is something that would be of great interests.
Sergey Kornilov admin 7/21/2005

Hi,
this error happens because MS Access has problems deleting records from queries that pull data from several tables.
Please post SQL query that defines OrderDetailsQuery.
C
 		chuckbragg author 7/21/2005

I changed my SQL statement like you had in the email you sent me but I still can not delete
Sergey Kornilov admin 7/22/2005

Hi,
answered to your personal e-mail.
M
 		mikehook 9/16/2006

Please post or email me the same answer , I have the same proble with deleting from access
Sergey Kornilov admin 9/19/2006

Mike,
usually Could not delete from specified tables error message means one of the following:

  1. Internet user don't have write/modify permissions on database folder
  2. Sometimes you cannot delete records from complex query that involves several (even if you still can delete records in MS Access). Sometimes you can tweak DELETE query to delete data from the main table directly.
    You can start by posting exact error message and table/query structure.
M
 		mikehook 9/22/2006

ASP error happened

Error number -2147467259

Error description [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.

SQL query delete from [tblDirectory] where [tblDirectory].[MainID]='201U' and [tblDirectory].[SubID]=110
Mike McCormick
Sergey Kornilov admin 9/22/2006

Mike,
is it table or query?
Are you able to Edit/Add data?