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

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
420 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,004 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
893 questions
0 comments No comments
{count} votes

Accepted answer
  1. Karl Donaubauer 2,056 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.