plegl.blogg.se

Recursive maze-solving algorithm or the large UPDATE.SELECT operations. I have a 50,000+ line, computationally-intensive VBA application built on Access 2007 that randomly gives me the message that "Access has stopped working." as Access just dies.

Thanks for helping make community forums a great place. We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. You can get more detail about it from link below: How to use command-line switches in Microsoft AccessĬan you creating a simple database and send it to the users who have the issue to see whether this issue was caused by spcefic code. In this simple database we can have a display form, and add an msgbox in the form open event. We can start the database using runtime by via command line add the "/runtime" parameter. If yes, I suggest that you to test the database in Access runtime to see whether the issue relative to Access runtime. I also would like to know 32-bit or 64-bit Access 2010 you are developing with. Thanks for the detail explaintation for this issue. I must also mention that I am using ODBC connections to extract some data from our Order system that is used in the Access application, but the error occurs before the connections are opened.Īnother Note: There are other Access applications running on this machine with no problems. It immediately comes up with the "Execution has stopped." error. On this specific computer, the application does not even open the logon form. MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure Form_Open of VBA Document Form_frmLogon" The code in the Sub FORM_OPEN as follows: The application then exports the user information to validate the user and password. When the application starts, it opens with a Logon form where the user must input their user name and password. The Access installation (runtime version) is The user where the error occurs, is 200 km away from me and they do not have the full installation of Access. I cannot debug the code on my laptop as I do not receive this error.