Macro error

Question

Hi,

The users have been using a database for over a year. This database has a simple macro to import data into an existing table. The macro is called by clicking on the logo on the main form (the form that automatically opens when you open the database).

Recently a user tried to open the database and run the macro on a computer that is not in either English or French. Ever since then whenever you open the database you get a security risk warning bar.

I have 9 different databases with the same macro and they all have the same warning bar now.

I tried the following:

• check the box to allow all macros (even it not recommended)
• tried to add the sharepoint site (https://NAME.sharepoint.com/sites/RESIDENCES/)
• I restored one of the database from backup (it works locally) but when I copy it to the share I get the warning
• I removed the macro from the button and when I open the database again I still get the warning

The tables, queries, forms and reports work, but the macro on the logo doesn't anymore.

I am at a loss as to how to fix this issue

Any help would be appreciated

Jeanne

Answer 1

Click the checkbox that says "Unblock".

Answer 2

So I read the article and as much as I try, I can never see the MOTW

I zipped it with 7-Zip (which I downloaded), I tried upzipping, I tried checking the properties before unzipping and nothing.

There has to be a way to remove this protection

Any ideas?

Thanks

Jeanne

Answer 3

Thank you.

That is the standard warning, I believe, albeit in French.

It probably means that the accdb in question was downloaded or received from the web and has had the Mark of the Web (MOTW) added to it.

The excellent blog article explains in some detail (which you may not want) but also explains how to address it.

Answer 4

Here is the security warning I get:

The language the databases were opened with is Russian and that's when all the databases stopped working.

I even created a database with a blank table and a form with a simple logo on, nothing else and I still got the error message.

Any idea?

Thanks

Jeanne

Answer 5

What, exactly, is the security warning?

Which language was on that non-English, non-French computer?

What, exactly, is that macro? Show us a screenshot, please, since you can't copy/paste macro contents directly.