Share via

Clean old SharePoint sites in "Get External Data" MSAccess wizard

Víctor 0 Reputation points
2023-02-03T13:18:28.5766667+00:00

The "Get External Data" MSAccess wizard keeps a list of every SharePoint site you ever used to link to in the "Specify a SharePoint site" list.

How can I clean this list?

This is particulary important if I need to distribute the Access database to external parties.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
343 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,323 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Haoyan Xue_MSFT 22,466 Reputation points Microsoft Vendor
    2023-02-06T09:28:03.2566667+00:00

    Hi @Víctor ,

    Currently no settings can be found to directly remove old SharePoint site url in the "Specify a SharePoint site" list.

    I packaged my database file and sent it to others, he can see the old SharePoint site urls list I browsed.

    You are right. Distributing the Access database to external parties would reveal these old SharePoint site urls.

    You could make your suggestion in this feedback portal to improve user experience. Thank you for your understanding and support.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.