Good day.
I maintain an MS Access database that connects to Oracle via ODBC. It's being working fine for years.
A few days ago the process to move data from one table to another is giving the error Could not delete from specified tables. According to my client, the process might run well for certain records but not for others.
The process runs as follow:
Run query to move the data to the other table. The query runs fine and moves the data.
Run query to delete the moved records from the original table. This is when the error occurs. The records to be deleted remains in the original table.
This is the query that is being running for a long time. Uses only one table. I have tried many of the recommendations in this and other forums with no results, including setting Unique Records to Yes.
DELETE DOCS_ADMIN_TBLBOX.PALETNUM, *
FROM ADMDOC_ADMIN_TBLBOX
WHERE (((DOCS_ADMIN_TBLBOX.PALETNUM)=getMyPalet())); getMyPalet is a public function that captures the value to be processed.
Your suggestions will be appreciated.
Thanks.
M. Garcia
Senior Programmer Analyst
Puerto Rico
I maintain an MS Access database that connects to Oracle via ODBC. It's being working fine for years.
A few days ago the process to move data from one table to another is giving the error Could not delete from specified tables. According to my client, the process might run well for certain records but not for others.
The process runs as follow:
Run query to move the data to the other table. The query runs fine and moves the data.
Run query to delete the moved records from the original table. This is when the error occurs. The records to be deleted remains in the original table.
This is the query that is being running for a long time. Uses only one table. I have tried many of the recommendations in this and other forums with no results, including setting Unique Records to Yes.
DELETE DOCS_ADMIN_TBLBOX.PALETNUM, *
FROM ADMDOC_ADMIN_TBLBOX
WHERE (((DOCS_ADMIN_TBLBOX.PALETNUM)=getMyPalet())); getMyPalet is a public function that captures the value to be processed.
Your suggestions will be appreciated.
Thanks.
M. Garcia
Senior Programmer Analyst
Puerto Rico