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.
DotNet Wang on Fri, 06 Jan 2017 01:50:31
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.
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
Neda Zhang on Tue, 10 Jan 2017 09:39:36
>>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.
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.