Execution of this application has stopped due to a run-time error.

Hi,
I developed an application with access and when I tried to deploy the application with the access runtime it gives me the following error:

"Execution of this application has stopped due to a run-time error"
"The application can't continue an it will shut down."

I look in the EE database and I try some of those solutions and it didn't work. I reinstall the Developer package and the entire Office as well. Also Microsoft says that it might be a problem if there are difference between the MDAC components from the original computer where you developed and the computer where you want to run the application, I tried using the same MDAC, but didn't help neither, this seems to be another Microsoft bug.

Any ideas or work arround for this ?

Thanks,
MylorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

stevbeCommented:
Does the runtime version work on your machine?

You need to put error handling on whatever is running on startup (you should put it on EVERYTHING) so you can find out what is really going wrong.

Steve
MylorAuthor Commented:
I run the program in my computer with the runtime and I get the same error.
stevbeCommented:
does the original mdb file work on your computer?
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

inoxCommented:

assuming you used adt or ode, this can happen:

- When you use an ActiveX control in a Microsoft Access application, the control may appear blank when the application is used in the run-time environment

- If you use the End statement in Visual Basic for Applications    
  code in a run-time application i.e:
  Sub CauseError()
   On Error GoTo Err_Handler
    MsgBox "Click OK to cause a run-time error"
    End
    Exit Sub
    Err_Handler:
    MsgBox Error$
  End Sub

- When you add a switchboard item to close a run-time application

and some other things


MylorAuthor Commented:
Thank you all, I called Microsoft and I send them the code; the problem was that some functions and code is not available in runtime mode, so, when you program in Access and deploy the application you have to be really carefull with your code.

This was the example (a File Dialog Box):

With _
Application.FileDialog(conFileDialogFilePicker)

        .ButtonName = "Select"
        Debug.Print "DialogType: " & .DialogType
        .Title = "Choose your files"
        .Filters.Clear
                .InitialFileName = txtOutputPath
                .Filters.Add "All Files", "*.*", 1
                .Filters.Add "Access databases", "*.mdb; *.mde", 2
                .Filters.Add "Excel Files", "*.xl?", 3
                .Filters.Add "Word Files", "*.doc", 4
                .FilterIndex = 3

        .InitialView = msoFileDialogViewDetails
        .Show

        If .SelectedItems.Count > 0 Then
                For Each varItem In .SelectedItems
                    strOut = strOut & varItem & vbCrLf
                Next varItem
        End If

End With

Thanks,

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
stevbeCommented:
You could have saved the call to Microsoft if you had error handling which would have identified the code causing the problem. We would have been able to help you find an alternative solution which in this case you can use the Win32 api function found at http://www.mvps.org/access/api/api0001.htm to provide a file dialog box in an Access runtime application.

Steve
MylorAuthor Commented:
Thanks Steve
woodsbwCommented:
I am experiencing the same "execution of this application has stopped due to a run-time error". The database is very simple with one table and three forms. With Access 2010 Run-time installed on an WinXP/SP3 machine the application runs on multiple mahcines except one machine. This one troublesome machine provides the error. I even went so far as to completely rebuild the machine from scratch (can't golf yet). The error still persists.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.