Active content in this file is blocked. Trust Center

Antonio Tudela 71 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.
562 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
271 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,173 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.
1,936 questions
0 comments No comments
{count} vote

Accepted answer
  1. AllenXu-MSFT 14,586 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
  1. Tanay Prasad 2,100 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.

    1 person found this answer helpful.
    0 comments No comments

  2. Asem Wagih 0 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

    0 comments No comments