Delete rows sharepointlist with query in access

%3CLINGO-SUB%20id%3D%22lingo-sub-1770149%22%20slang%3D%22en-US%22%3EDelete%20rows%20sharepointlist%20with%20query%20in%20access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1770149%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20linked%20Access%20to%20a%20SharePoint%20list.%20I%20use%20an%20Query%20to%20update.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20update%20with%20an%20updatequery%20with%20no%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20can't%20delete%20the%20rows%20not%20in%20use%20anymore.%20with%20a%20Delete%20Query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20it%20is%20the%20Title%20field%20making%20troubles%2C%20if%20I%20run%20a%20Delete%20Query%20I%20can't%20delete%20Title%20field%2C%20but%3C%2FP%3E%3CP%3Eall%20other%20fields.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20anyone%20have%20a%20solution%20for%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1770149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi

 

I have linked Access to a SharePoint list. I use an Query to update.

 

I can update with an updatequery with no problem.

 

But can't delete the rows not in use anymore. with a Delete Query.

 

I think it is the Title field making troubles, if I run a Delete Query I can't delete Title field, but

all other fields.

 

Do anyone have a solution for this?

0 Replies