Appcrash - my app suddenly stops and crashes

[Mgomp]

Hi all.

I am "develeooping" an app, which have becam an app with several forms, lots of reports, querys. It's based on a Front-end and Back-end system. The front end have grown to a 2,6MB size after comapct and repair.
My company are using lots of HP laptops, and today i think there are about 25 - 30 persons which are using the app.

Problem:
In the past, I have seen the app is crashing for no obvious reason. It just halts and terminates.
All computers are running Windows 7 and Access 2010, but there are different models of HP laptops. The second problem is, its only av few persons/computers which have this problem, and it's not happend on the same place for those who have the problem. On one of the computer, I got an extended infor about the error message, and hopefully somebody understand the problem and may have a soultion for me:

Problem signature:
Problem Event Name: APPCRASH
Application Name: MSACCESS.EXE
Application Version: 14.0.4750.1000
Application Timestamp: 4b8bade7
Fault Module Name: VBE7.DLL
Fault Module Version: 7.0.15.90
Fault Module Timestamp: 4b7b1248
Exception Code: c0000005
Exception Offset: 000463e9
OS Version: 6.1.7601.2.1.0.256.4
Locale ID: 1044

Additional information about the problem:
LCID: 1033
skulcid: 1033

(+ some links to privacy statements)

Googling exception Code and Offset didn't give me any help...

Regards.

 

[Guus2005]

IMHO, i think your database is corrupted.

Open a new empty database and copy ALL objects from the old database to the new one by importing objects.
This should get rid of all bugs and other insects which accumulated in your code over the time.

HTH

 

[Mgomp]

Thank you for your reply, Guus2005

The soultion was however not a big deal, when I understand where to look..

What I did, after a normal "compact & repair" was;
- In VBA Editor for the app, I select Debug and Compile Appname. Repair foult/comment if any.
- Then I create a shortcut on my desktop to with the syntax/target:
"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" "X:\Appname.accdb" /decompile

I remebered the /decompile from a another problem, and just for fun I tried it.
The APPCRASH is no longer a problem (for now...)

Regards.