MS Access upgraded to Office 365 version

[dollygg]

Hi all, I found something very odd after the upgrade. Those queries ( make table query, update query and insert into query) always fail on the first run.

eg. I have 10 queries in a macro, that means it will fail 10 times before it successfully went through. How to avoid this happen? The reference library had been refreshed to 16.0 .

[isladogs]

I've never experienced this problem in any of my apps and I've been using 365 for several years.

Do the queries run successfully first time if run from the nav pane or using DoCmd.OpenQuery ... or similar?

It may be corruption in your project. Make a backup then try decompiling your project, followed by compact & repair and finally recompile

[dollygg]

I have old .mdb file. The code behind the macro button is "Docmd.openquery queryname".
I will try to compact and repair. Thanks.

[dollygg]

Actually I found the solution.

The primary reason behind this error is that MS Access does not trust the database from which the macro is run. By default, Access opens databases that are not trusted in the Disabled mode. In the Disabled mode, executable content is disabled, preventing you from running a macro.


How to Fix Microsoft Access Database Error 2950? (stellarinfo.com)