Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 10417
  • Last Modified:

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,
0
Mylor
Asked:
Mylor
1 Solution
 
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
0
 
MylorAuthor Commented:
I run the program in my computer with the runtime and I get the same error.
0
 
stevbeCommented:
does the original mdb file work on your computer?
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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


0
 
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,
0
 
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
0
 
MylorAuthor Commented:
Thanks Steve
0
 
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.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now