Microsoft Access: A potential security concern has been identified

Question

I am trying to import Excel files into Access 2019 which I have done many times. Suddenly, when I try to get an Excel file, I get the error message cited. If I click Open, I can go through the steps of importing the file but it won't save the new .mdb file. It fails with any Excel file I try.

Answer 1

Give back to the Community, Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Warm Regards

Answer 2

My apologies, I got s bit confused. The import worked perfectly and the new table was created.

Thanks again, problem was solved.

Answer 3

Unfortunately, when the import steps were completed and I click Finish it tells me that my import was saved but I cannot find any new .mdb files on the disk.

When you import an Excel file, it is imported INTO the currently open Access file. If you opened an mdb file then the data imported will be in the table you imported to in THAT file.

Answer 4

Thank you for your quick reply.

I followed the steps you outlined and I did not get the error message when I imported an Excel file.

Unfortunately, when the import steps were completed and I click Finish it tells me that my import was saved but I cannot find any new .mdb files on the disk.

Answer 5

Hello kgash,

Welcome to Microsoft Community.

I am a Microsoft user just like you, I hope you are doing well?

Kindly follow steps below to troubleshoot this issue:

1. Click on file and then options.
2. Click on trust center and then trust center settings on the right.
3. Click on trusted locations and add new location
4. Browse and select the location and Save.

Please let me know if you need more assistance.

Give back to the Community, Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Warm Regards