asked on I get an error message when connecting to an access database
In vb.net, 2015- when I connect to an access database, with the following code:
Dim StnStr() As String
StnStr = "Data Source=servername; Initial Catalog=databasename; User ID=userid; Password=password"
StnStr = "Provider=MSDataShape;Data
StnStr = StnStr & "Jet OLEDB:System database=" & My.Application.Info.Direct
StnStr = StnStr & "Password=PW;User ID=USERNAME;"
StnStr = StnStr & "Data Source=" & My.Application.Info.Direct
StnStr = StnStr & "Persist Security Info=False"
Dim CON As New OleDb.OleDbConnection(StnS
CON.Open()
I receive the following error message in the output window:
The program '[3660] UpdateCrgs.vshost.exe' has exited with code -1073741819 (0xc0000005) 'Access violation'.
What can this mean?
In other projects it seems fine, why in this project am I getting this message?
Dim StnStr() As String
StnStr = "Data Source=servername; Initial Catalog=databasename; User ID=userid; Password=password"
StnStr = "Provider=MSDataShape;Data
StnStr = StnStr & "Jet OLEDB:System database=" & My.Application.Info.Direct
StnStr = StnStr & "Password=PW;User ID=USERNAME;"
StnStr = StnStr & "Data Source=" & My.Application.Info.Direct
StnStr = StnStr & "Persist Security Info=False"
Dim CON As New OleDb.OleDbConnection(StnS
CON.Open()
I receive the following error message in the output window:
The program '[3660] UpdateCrgs.vshost.exe' has exited with code -1073741819 (0xc0000005) 'Access violation'.
What can this mean?
In other projects it seems fine, why in this project am I getting this message?
Microsoft AccessMicrosoft ApplicationsVisual Basic Classic
Last Comment
Nick67
ASKER
I have the same situation if I use
Provider=Microsoft.Jet.OLE
Provider=Microsoft.Jet.OLE
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
StnStr = "Provider=MSDataShape;Data Provider=Microsoft.Jet.OLE
https://msdn.microsoft.com/en-us/library/ms254500(v=vs.110).aspx
Are you sure that the MSDataShape provider is in use with an .mdb data source?
And are you sure you want to carry on with that, as it seems that MS is deprecating it?
https://msdn.microsoft.com/en-us/library/ms676105(v=vs.85).aspx