Forum Discussion
Solved
Access connected to sharepoint list
Hi I have 2 list I update from Access to sharepoint. First list I run 3 query (Add, Update, Delete) no problems. Second Liste the same 3 query (Add, Update, Delete). When i come to the last ...
"it is working inside access, so it have to a problem in the SQL"
I assume you mean that a delete query does delete the records. Well, that means the SQL in that query is right, but the SQL generated in the VBA is not right. And that's the SQL I would like to see tested. Thanks.
This indeed sounds to me like a limitation on the SharePoint side. You'd have to wrestle an explanation out of the SP Site admins if you can get them to pay attention.