C
Clink72
Guest
Hello,
I hope I am asking this question in the correct forum.
I have Visual Studio Community 2015 and Access 2016 running on a new PC build, Windows 10 Pro.
I am working on a program that requires reading and writing to a very simple database. I created the db in Access (2 tables linked with primary key).
When I try to add the data source to the vb.net project, I am getting the error Unrecognized Database Format and then the path.
A similar project worked just fine on my previous machine (VS 2015 / Access 2010 / Windows 7 Pro). I have read countless threads on this subject around 2007 and 2010, something about accdb files that I am not tracking and lots of talk about ACE.OLEDB.12.0.
The following is exactly what I am doing (wizard):
Add New Data Source --> databse --> Dataset --> New Connection --> Microsoft Access Database File --> select the accdb file --> Test Connection = fail
If I click on advanced, Provider is Microsoft.Jet.OLEDB.4.0
Interestingly, on the Choose Your Data Connection page (where you click on new connection), the connection string Provider is
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\dbTeam.accdb
(dbTeam.accdb is the file I am trying to use)
I am at a loss here. Any suggestions or thoughts would be greatly appreciated. Has something changed with the new access that is throwing this? I presume Windows 10 VS 7 pro isn't the issue.
Thank you
Chris
Continue reading...
I hope I am asking this question in the correct forum.
I have Visual Studio Community 2015 and Access 2016 running on a new PC build, Windows 10 Pro.
I am working on a program that requires reading and writing to a very simple database. I created the db in Access (2 tables linked with primary key).
When I try to add the data source to the vb.net project, I am getting the error Unrecognized Database Format and then the path.
A similar project worked just fine on my previous machine (VS 2015 / Access 2010 / Windows 7 Pro). I have read countless threads on this subject around 2007 and 2010, something about accdb files that I am not tracking and lots of talk about ACE.OLEDB.12.0.
The following is exactly what I am doing (wizard):
Add New Data Source --> databse --> Dataset --> New Connection --> Microsoft Access Database File --> select the accdb file --> Test Connection = fail
If I click on advanced, Provider is Microsoft.Jet.OLEDB.4.0
Interestingly, on the Choose Your Data Connection page (where you click on new connection), the connection string Provider is
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\dbTeam.accdb
(dbTeam.accdb is the file I am trying to use)
I am at a loss here. Any suggestions or thoughts would be greatly appreciated. Has something changed with the new access that is throwing this? I presume Windows 10 VS 7 pro isn't the issue.
Thank you
Chris
Continue reading...