Forum Discussion

Storming's avatar
Storming
Brass Contributor
Jun 12, 2022
Solved

Macros not opening

Hi, my Access database which has been running for 4 years has all of a sudden developed a problem with macros. I can edit all objects no problem apart from when I try to edit any macro the databse ju...
Access 2016 macros
  • Karl_Donaubauer's avatar
    Karl_Donaubauer
    Jun 13, 2022

    Hi,

    First try to open macros in a different database than the problematic one. If that works, create a new database and import all objects from the corrupted database and try if it works again.

     

    Servus
    Karl
    Access News
    Access DevCon

Karl_Donaubauer's avatar
Karl_Donaubauer
MVP
Jun 13, 2022

Hi,

First try to open macros in a different database than the problematic one. If that works, create a new database and import all objects from the corrupted database and try if it works again.

 

Servus
Karl
Access News
Access DevCon

  • Storming's avatar
    Storming
    Brass Contributor
    Jun 13, 2022

    Karl_Donaubauer 

     

    Thanks Karl.

    I had already tried that but all objects would not import and the import kept failing.

    I have finally identified 2 form objects which would not import.

    So I have created a new database with all objects except those 2 and reimported the 2 from an earlier back up I had.

    All appears to be working now, thanks for your help.

Resources