Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Access delete query not deleting records

Copper Contributor


Not sure if anyone can help...I set up 2 tables in Access and want to delete the matching records by joining ID fields. 

I get an error message: Could not delete from specified table.

The database is local on my desktop and properties are set to "allow' for everything.

2 Replies
Please post your query's SQL statement for us to review.


Because we have no visibility to your computer, nor to your accdb, we have to rely entirely on the information provided. Hence, Daniel's request to see the ACTUAL SQL involved. 

We're looking for things that might make a query non-updateable.