Run Time error 3156 ODBC Delete on a linked table TABLENAME failed

[nani]

Hi ,


Since from one week i am facing problem in msaccess can any one solve this problem its urgent
The problem is
"Run Time error 3156 ODBC Delete on a linked table TABLENAME failed"
Initially iam retrieving the data from multiple tables and later inserting the data into the table the table consists of 6000 records the query as follows:
query:
INSERT INTO tblProposal_Search_Result (Specification_Nbr, Specification_Version, Request_Date, REASON_REQUEST, CAS_Nbr, Chemical_Name, Product_Name, Business_Unit_Description, Customer_Name, Specification_Type_Description, Specification_Status_Desc)
SELECT Specification_Nbr, Specification_Version, Request_Date, TBLREQUEST_CATEGORY.REQUEST_CATEGORY_DESCRIPTION, CAS_Nbr, Chemical_Name, Product_Name, Business_Unit_Description, tblSpecification.Customer_Name, Specification_Type_Description, Specification_Status_Desc FROM ((((tblSpecification LEFT JOIN tblBusiness_Unit ON tblSpecification.Business_Unit_Code = tblBusiness_Unit.Business_Unit_Code) LEFT JOIN tblSpecification_Type ON tblSpecification.Specification_Type_Code = tblSpecification_Type.Specification_Type_Code) LEFT JOIN tblSpecification_Status ON tblSpecification.Status_Code = tblSpecification_Status.Specification_Status_Code) LEFT JOIN TBLREQUEST_CATEGORY ON tblSpecification.REQUEST_CATEGORY_CODE = TBLREQUEST_CATEGORY.REQUEST_CATEGORY_CODE)
WHERE Specification_Version - INT(Specification_Version) > 0


After inserting the records into the table and displaying 6000 records from table to the user and Iam executing the delete statement to delete the data from inserted table.
query:
DELETE * FROM tblProposal_Search_Result(table name)
But it could not able to delete the records and throwing an exception as:

"Run Time error 3156 ODBC Delete on a linked table TABLENAME failed"

[Toyman]

Hi ,
Since from one week i am facing problem in msaccess can any one solve this problem its urgent
The problem is
"Run Time error 3156 ODBC Delete on a linked table TABLENAME failed"
Initially iam retrieving the data from multiple tables and later inserting the data into the table the table consists of 6000 records the query as follows:
query:
INSERT INTO tblProposal_Search_Result (Specification_Nbr, Specification_Version, Request_Date, REASON_REQUEST, CAS_Nbr, Chemical_Name, Product_Name, Business_Unit_Description, Customer_Name, Specification_Type_Description, Specification_Status_Desc)
SELECT Specification_Nbr, Specification_Version, Request_Date, TBLREQUEST_CATEGORY.REQUEST_CATEGORY_DESCRIPTION, CAS_Nbr, Chemical_Name, Product_Name, Business_Unit_Description, tblSpecification.Customer_Name, Specification_Type_Description, Specification_Status_Desc FROM ((((tblSpecification LEFT JOIN tblBusiness_Unit ON tblSpecification.Business_Unit_Code = tblBusiness_Unit.Business_Unit_Code) LEFT JOIN tblSpecification_Type ON tblSpecification.Specification_Type_Code = tblSpecification_Type.Specification_Type_Code) LEFT JOIN tblSpecification_Status ON tblSpecification.Status_Code = tblSpecification_Status.Specification_Status_Code) LEFT JOIN TBLREQUEST_CATEGORY ON tblSpecification.REQUEST_CATEGORY_CODE = TBLREQUEST_CATEGORY.REQUEST_CATEGORY_CODE)
WHERE Specification_Version - INT(Specification_Version) > 0


After inserting the records into the table and displaying 6000 records from table to the user and Iam executing the delete statement to delete the data from inserted table.
query:
DELETE * FROM tblProposal_Search_Result(table name)
But it could not able to delete the records and throwing an exception as:

"Run Time error 3156 ODBC Delete on a linked table TABLENAME failed"

Try this:
DELETE * FROM tblProposal_Search_Result

It is the sql statement without the "(table name)"