I haven't been able to find anything regarding this out there so hoping someone may be able to help out.
I have a list out on SharePoint that I link back into Access to query and run reports based off off. I have a query that runs to archive these records each month to a table. What I need to do after this archive is done is delete those records from the SharePoint list. I set up a delete query to run based upon the ID within the record but when I go to run the query I am getting an error stating "Could not delete from specified table". Not sure if I just have something wrong within my query or if it is due to being a linked SharePoint list.
DELETE [Tasks].*, [Tasks].ID
FROM [Tasks], [archive 201502]
WHERE ((([Tasks].ID)=[archive 201502]![ID]));
Any help would be great.
Thanks,
I have a list out on SharePoint that I link back into Access to query and run reports based off off. I have a query that runs to archive these records each month to a table. What I need to do after this archive is done is delete those records from the SharePoint list. I set up a delete query to run based upon the ID within the record but when I go to run the query I am getting an error stating "Could not delete from specified table". Not sure if I just have something wrong within my query or if it is due to being a linked SharePoint list.
DELETE [Tasks].*, [Tasks].ID
FROM [Tasks], [archive 201502]
WHERE ((([Tasks].ID)=[archive 201502]![ID]));
Any help would be great.
Thanks,