Fix Cannot Delete Records from Access Table Linked to SharePoint

Open the SharePoint list in your web browser and ensure it contains a unique identifier, such as the built-in 'ID' column.

Switch to Microsoft Access, go to the External Data tab, and click on 'Linked Table Manager'.

Check the box next to your problematic SharePoint linked table and click 'OK' to refresh the connection. This ensures the unique ID column is accurately pulled into Access.

In Access, right-click your Delete query and select 'SQL View'.

Verify whether the field you are filtering by (e.g., SerialNo) is formatted as a Number or Short Text in the table design.

If the field is text, enclose the target values in single quotation marks. For example: DELETE FROM TblMachHist WHERE SerialNo IN ('75944','75945');

Click 'Run' on the query design ribbon to test if the records delete successfully.

Double-click the linked SharePoint table in the Access navigation pane to open it in Datasheet View.

Highlight a single test record that you wish to delete by clicking the row selector on the left.

Press the 'Delete' key on your keyboard. If prompted, confirm the deletion.

If manual deletion throws an error, consider deleting the items directly in the SharePoint web interface or using Microsoft Power Automate for bulk deletions.