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...
Access 2000
Access vba
VBA
arnel_gp's avatar
arnel_gp
Steel Contributor
Apr 08, 2023
did you really tried all possible solutions?
that include converting your Old db to Newer db (compatible to A2019 or better?)
Stratus78's avatar
Stratus78
Copper Contributor
Apr 09, 2023

arnel_gp 

Hi, a colleague of mine tried translating the project from adp to accdb but failed. 

I don't know what to try anymore or who to ask.

Do you have any idea?

 

Thank you

  • Stratus78's avatar
    Stratus78
    Copper Contributor
    Apr 11, 2023
    HI,
    I found the solution to the problem:
    add msaccess on
    system-->system setting
    advanced-->performance-->settings-->program execution prevention.
    press add and select msaccess.exe.

    Thanks for your help.
  • David_Richardson's avatar
    David_Richardson
    Copper Contributor
    Apr 11, 2023

    Stratus78   You might want to try just upgrading in increments.  I understand your pain with ADP.  I have an ADP program that needs to be converted as well, but it can be a monumental task.  Try upgrading it to an Access 2003 ADP file.  That is the last version that supported ADP if memory serves.  But you can run ADPs all the way up to Office 2010... Right now I have a VM running Window 10 with Office 2010 running an ADP application and its working fine... but remember they stopped supporting ADP in I believe SQL Server 2008, though  you could try running it on newer versions in compatibility mode.  Good Luck...