Share via

Modifier LISTE SHAREPOINT depuis MS ACCEESS

Youssef Taoudi 45 Reputation points
2024-11-29T13:16:59.3866667+00:00

Bonjour,

j'ai une liste SHAREPOINT que j'alimente/consulte, etc... sans problème depuis Microsoft ACCESS 2019.

Mon problème est le suivant:

Quand je lance une requête de MISE A JOUR pour mettre à jour ma liste SHAREPOINT ou une requête de SUPPRESION pour vider ma LISTE SHAREPOINT, Access me demande de confirmer la mise à jour ou la suppression (voir image).

Capture d’écran 2024-11-29 135915

Dans le menu OPTION, j'ai décoché toutes les case de CONFIRMATION (voir image)

2

cependant, si je rentre dans cette même LISTE Sharepoint toujours depuis ACCESS et j'élimine un ou plusieurs registres manuellement, ACCESS ne me sort aucun Message de demande de confirmation.

Avez vous une idée pour eliminer ce message car je veux automatiser la mise a jour et suppression de données de ma LISTE Sharepoint.

merci beaucoup

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
Accepted answer
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Youssef Taoudi 45 Reputation points
    2024-12-02T14:51:51.5333333+00:00

    I have received the solution in another forum:
    https://zcusa.951200.xyz/en-us/answers/questions/2124600/sharepoint-and-ms-access-2019

    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

    0 comments

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.