Program runs fine in Design View crashes in Access Run Time

[randommetalguy]

Hello,

I've developed this program and sometime over the past 3 weeks there must have been an Access update affecting my program. When I run my program from the Form View I do not have any errors and my program runs fine. I have packaged up the file and reinstalled it and now whenever I try to go to another form the Access runtime environment crashes when I run the program in .exe form.

http://blogs.msdn.com/access/archive/2009/04/29/access-2007-and-runtime-sp2-now-available.aspx

Currently I am in the process of installing all of the updates at that link. Could someone help me with this problem? I'll be glad to provide further details I realize my question is kind of vague.

 

[HiTechCoach]

In .exe form? I think you mean compiled into a ACCDE. Is this correct?

It sounds like you need to also include a better error handling. When using the Access runtime, you must include error handling everywhere. Any un-trapped error cause the runtime to shutdown.

See if this helps:
Access 2007 runtime deployment - FAQs

What I have fodun is that if you were not using Access 2007 with the SP2 update installed for development, it was your machine causing the issues, bnot the runtomes that have SP2 installed.

Until SP2 can out, I would recommend against anyone using Access 2007.