?
Solved

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

Posted on 2003-11-07
10
Medium Priority
?
10,092 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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
 

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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

752 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