VB app hanging with the ;preparing to install

Category: visual studio vb

Question

TEWhites1 on Thu, 05 Jan 2017 14:40:43


I have a VB app which accessed an Access database (and it worked).  Debugging it now fails with a "LoaderLock" error.  I have tried to clear the exception, then the system gets hung up with a "preparing to install". 

I have since tried to create a new application with vb using an Access DB and they get hung up.  I have tried vb 2008, 2012, 2013, and 2015 all with the same results.

Here is what I tried using VB 2015 Express

Open VB Express

Select New Project

Select Windows Forms Application.  VB opens with Form1

Select View, Other Windows, Data Sources, Add New Data Source

Select Database, Pick Next, Select Dataset. Pick Next,

Select New Connection, Pick Microsoft Access Data File, Pick Continue

Enter Database File Name (A good MS Access (2010) database)

Pick Test Connection

A Window "Windows Installer"  pops up saying "Preparing to Install..."

And it hangs here forever.

I think the solution to this will also fix my original problem to my program

I have searched the internet and tried every solution offered.  If anyone has any ideas I would greatly appreciate them.


Replies

DotNet Wang on Fri, 06 Jan 2017 01:50:31


Hi TEWhites,

Thank you for your post.

Firstly, please check whether there are error logs in Windows Event Viewer. You could open Event Viewer by clicking Start, then point to Programs, point to Administrative Tools, and then click Event Viewer

In addition, which version of Access database did you use? Please check you have install the driver for the version of Access. You could download and install the driver from following links if needed.

Microsoft Access Database Engine 2010 Redistributable

Microsoft Access 2013 Runtime

Microsoft Access 2016 Runtime

Best Regards,
Li Wang

TEWhites1 on Fri, 06 Jan 2017 15:09:31


In my attempts on trying to find the problem I decided to try the same exercise of creating a new project with a database connection.  I selected new project and added a database connection but this time I connected to a database created with Access 2007. This was successful.   Repeating the same exercise again with Access 2013, I get the windows installer window with "preparing to install and never finishes.  The only way to end is through task manager and end task

TEWhites1 on Fri, 06 Jan 2017 15:46:27


My big question is what is it trying to install

TEWhites1 on Fri, 06 Jan 2017 17:03:21


Here is a simple VB 2013 program that gives me the "windows installer"

This occurs on the myConnection.Open()

 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        Dim provider As String
        Dim dataFile As String
        Dim connString As String
        Dim myConnection As OleDbConnection = New OleDbConnection
        Dim dr As OleDbDataReader

        provider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source ="
        dataFile = "C:\Users\Tom\Documents\Products.accdb" ' Change it to your Access Database location        connString = provider & dataFile
        connString = provider & dataFile
        myConnection.ConnectionString = connString

        myConnection.Open()

        myConnection.Close()

    End Sub

Neda Zhang on Tue, 10 Jan 2017 09:39:36


Hi TEWhites1,

>>Here is a simple VB 2013 program that gives me the "windows installer". This occurs on the myConnection.Open()

Could you please post complete error message, or some screenshots? It will help us analyze and diagnose this issue more clearly.

Best Regards,

Neda Zhang




MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


Cor Ligthert on Tue, 10 Jan 2017 10:17:20


most probably it is around this what has to be used. 

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Otherwise try it with your program to X86 only