Solved

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

Posted on 2003-11-07
10
9,316 Views
Last Modified: 2011-04-03
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,
0
Comment
Question by:Mylor
10 Comments
 
LVL 39

Expert Comment

by:stevbe
ID: 9703091
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
0
 

Author Comment

by:Mylor
ID: 9703132
I run the program in my computer with the runtime and I get the same error.
0
 
LVL 39

Expert Comment

by:stevbe
ID: 9703184
does the original mdb file work on your computer?
0
 
LVL 4

Expert Comment

by:inox
ID: 9703843

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


0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Accepted Solution

by:
Mylor earned 0 total points
ID: 9717612
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,
0
 
LVL 39

Expert Comment

by:stevbe
ID: 9721524
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
0
 

Author Comment

by:Mylor
ID: 9724493
Thanks Steve
0
 

Expert Comment

by:woodsbw
ID: 35309770
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.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now