Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
I get an error message when connecting to an access database
Posted on 2016-07-18
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?
[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
2
3 Comments
I'm a thinkin' this is a little hatched
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month4 days, 1 hour left to enroll
630 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.