SHAREPOINT and MS ACCESS 2019

Youssef Taoudi 45 Reputation points
2024-11-29T13:21:18.3333333+00:00

Hello,

I have a SHAREPOINT LIST that I feed/consult, etc... without problem since Microsoft ACCESS 2019.

My problem is the following:

When I launch from ACCESS an UPDATE query to update my SHAREPOINT list or a DELETE query to empty my SHAREPOINT LIST, ACCESSs asks me to confirm the update or deletion (see image).
Capture d’écran 2024-11-29 135915

In the OPTION menu, I unchecked all the CONFIRMATION boxes (see image)
2

however, if I enter this same Sharepoint LIST still from ACCESS and I delete one or more registers manually, ACCESS does not give me any confirmation request message.

Do you have any idea to eliminate this message because I want to automate the update and deletion of data from my Sharepoint LIST.

thank you very much

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
0 comments No comments
{count} votes

Accepted answer
  1. Karl Donaubauer 2,061 Reputation points MVP
    2024-11-29T14:13:29.1733333+00:00

    Hi,

    Yes, that's a problem with linked Sharepoint lists. The good news is that when you automate the queries with macros or VBA code you can avoid the confirmation messages. In VBA you can use the DAO execute method e.g.

    CurrentDb.Execute "YourActionQuery", dbFailOnError

    which doesn't raise the (Access) confirmation messages.

    The other method is to explicitely suppress the warnings:

    DoCmd.SetWarnings False
    DoCmd.OpenQuery "YourActionQuery"
    DoCmd.SetWarnings True

    This is also available as a macro action (in fact VBA calls the macro action here).

    Servus
    Karl


    Access Forever News DevCon
    Access-Entwickler-Konferenz AEK

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.