Share via

Active content in this file is blocked. Trust Center

Antonio Tudela 76 Reputation points
2023-07-24T11:26:34.7566667+00:00

I am trying to migrate several tables from Microsoft Access file located on channel into teams to Microsoft SharePoint online. When I try to do it using "DataBase tool" --> "SharePoint" and select the SharePoint site appears the next issue:

User's image

I changed some values from trusted sites in MS Access without luck. Anyone has the same problem and has a solution? Many thanks.

Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
654 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
402 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,904 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,200 questions
Accepted answer
  1. AllenXu-MSFT 21,286 Reputation points Microsoft Vendor
    2023-07-25T02:13:36.9433333+00:00

    Hi @Antonio Tudela,

    The "active content" in Access refers to any code or macros within the database that can execute. So go to File >> Options >> Trust Center >> Trust Center Settings... >> Macro settings >> Check "Enable VBA macros (not recommended; potentially dangerous code can run)" >> Click OK to save.

    User's image

    Please let me know if you still need assistance. It will be my pleasure to assist you.

    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.

    3 people found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tanay Prasad 2,140 Reputation points
    2023-07-25T05:59:02.5533333+00:00

    Hi,

    As Allen said above, you can try doing that. If that doesn't solve the issue, try the following methods-

    1. Windows may block the database file (.accdb) if it was downloaded from the internet or another unreliable source. If the option to unblock the file appears when you right-click on the.accdb file, select "Properties" from the menu, and then click "Unblock."
    2. In Microsoft Access, add the folder containing the.accdb file for your Access database to the list of trusted locations. By selecting "Trusted Locations" in the "Trust Center" settings and entering the folder path, you can accomplish this.
    3. Check to see if the database operation is being blocked by your firewall or antivirus settings. Disable your firewall or antivirus software momentarily and try again.
    4. Make sure you have the appropriate permissions in SharePoint to access the SharePoint site and migrate tables.

    Best Regards.

    4 people found this answer helpful.
  2. Asem Wagih 5 Reputation points
    2023-11-09T12:32:40.2566667+00:00

    1- Right click on your data base file.

    2- choose properties.

    3-in general tab , security section , check unblock box and click apply>ok.

    Picture1

    1 person found this answer helpful.
    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.