Forum Discussion

Stratus78's avatar
Stratus78
Copper Contributor
Apr 07, 2023

Appcrash Access / VBA

Hi,

 

I am part of a development team that has an application written in access / vba (access runtime 2000) in production and without installing any updates on some machines, with the Windows 10/11 operating system, the program no longer starts.

Searching the internet, we found this article:

https://learn.microsoft.com/en-gb/DeployOffice/security/internet-macros-blocked#use-policies-to-manage-how-office-handles-macros

 

Could the problem be related to this update?
We tried following the guidelines to get it back up and running but couldn't fix it.

Has anyone faced and solved any similar problem?

Thanks for any help.

 

---

 

Salve,

faccio parte di un team di sviluppo che ha in produzione un'applicazione scritta in access / vba (access runtime 2000) e senza l'installazione di nessun aggiornamento su alcune macchine, con sistema operativo Windows 10/11, il programma non parte piĆ¹.

Eseguendo delle ricerche su internet abbiamo trovato questo articolo:

https://learn.microsoft.com/en-gb/DeployOffice/security/internet-macros-blocked#use-policies-to-manage-how-office-handles-macros

Il problema potrebbe essere collegato a questo aggiornamento?
Abbiamo provato ad seguire le linee guida per ripristinare il funzionamento ma non siamo riusciti a risolvere.

Qualcuno ha affrontato e risolto qualche problema simile?

Grazie per un eventuale aiuto.

 

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    Stratus78 

    Because you have an existing mdb and did not download it from internet, it  is not likely that the problem is related to the new macro blocking policy.

     

    However, you are still running Access runtime 2000? Is that correct? 

    • Stratus78's avatar
      Stratus78
      Copper Contributor

      George_Hepworth 

       

      Thanks for your answer.

      What I understood is that the VBA code is blocked.

      In fact, even creating a word 2000 file with a simple open event, word crashes during opening.

       

      Private Sub Document_Open()
      '
      End Sub

       

  • arnel_gp's avatar
    arnel_gp
    Steel Contributor
    the reason that it won't open is the db is in old format.
    convert it to At least 2007 version.

    note i donwloaded northwind 2000 on my PC with A2021 and it wont open.
    • Stratus78's avatar
      Stratus78
      Copper Contributor
      HI,
      this is not the case because i run an adp with the connection to Sql Server using access runtime 2000.

      So no file conversion took place.

      In fact, as I said before, even if I simply open a Word 2000 file, the program crash.

      Thank you
      • arnel_gp's avatar
        arnel_gp
        Steel Contributor
        runtime will work without access being installed.
        do you have access installed on the computer you want to run this db?
        if you have which version?
        you can also google of what version of MS Office will run on Windows 10/11.
  • You should be able to open any A2000 format database in all current versions of Access. That includes Northwind 2000 which I can open kn A365. In fact, by coincidence, I will be using that as part of a presentation on automatic form resizing to Access DevCon next week,

Resources