Unrecognized database format'C:…Employees.accdb for Microsoft Access Database File?
I am trying to access a file stored in a Microsoft access database.(I am working in Visual Studio 2012) I chose the Database source type, and the Dataset database model, when it asks me "which data connection should your application use to connect to the database?", I clicked New Connection, then i chose Microsoft Access Database File (OLE DB). Under Database file name, i clicked browse and selected the appropriate file(Employees.accdb). When i press Test Connection or Ok i get this error: Unrecognized database format'C:.....Employees.accdb. Any ideas as to what i am doing wrong?
vb.net ms-access visual-studio-2012
asked Apr 18 '14 at 18:49
00000000
4672619
|
show 3 more comments
I am trying to access a file stored in a Microsoft access database.(I am working in Visual Studio 2012) I chose the Database source type, and the Dataset database model, when it asks me "which data connection should your application use to connect to the database?", I clicked New Connection, then i chose Microsoft Access Database File (OLE DB). Under Database file name, i clicked browse and selected the appropriate file(Employees.accdb). When i press Test Connection or Ok i get this error: Unrecognized database format'C:.....Employees.accdb. Any ideas as to what i am doing wrong?
vb.net ms-access visual-studio-2012
asked Apr 18 '14 at 18:49
00000000
4672619
Show your connection string....
– Steve
Apr 18 '14 at 18:51
im sorry completely new to database stuff, how do i do that?
– 0000
Apr 18 '14 at 19:03
if it helps the file is on my computer
– 0000
Apr 18 '14 at 19:07
1
The problem is probably due to an incorrect OleDb driver selected by the wizard that builds your connection string. (The string used to connect to your database)
– Steve
Apr 18 '14 at 19:12
4
Right click your connection in the Server Explorer, choose Modify Connection, Click Advanced, look at the line Provider. You should haveMicrosoft.ACE.OLEDB.12.0as provider notMicrosoft.Jet.OLEDB.4.0(the latter cannot recognize database in ACCDB format)
– Steve
Apr 18 '14 at 19:17
|
show 3 more comments
I am trying to access a file stored in a Microsoft access database.(I am working in Visual Studio 2012) I chose the Database source type, and the Dataset database model, when it asks me "which data connection should your application use to connect to the database?", I clicked New Connection, then i chose Microsoft Access Database File (OLE DB). Under Database file name, i clicked browse and selected the appropriate file(Employees.accdb). When i press Test Connection or Ok i get this error: Unrecognized database format'C:.....Employees.accdb. Any ideas as to what i am doing wrong?
vb.net ms-access visual-studio-2012
asked Apr 18 '14 at 18:49
00000000
4672619
I am trying to access a file stored in a Microsoft access database.(I am working in Visual Studio 2012) I chose the Database source type, and the Dataset database model, when it asks me "which data connection should your application use to connect to the database?", I clicked New Connection, then i chose Microsoft Access Database File (OLE DB). Under Database file name, i clicked browse and selected the appropriate file(Employees.accdb). When i press Test Connection or Ok i get this error: Unrecognized database format'C:.....Employees.accdb. Any ideas as to what i am doing wrong?
vb.net ms-access visual-studio-2012
vb.net ms-access visual-studio-2012
asked Apr 18 '14 at 18:49
00000000
4672619
asked Apr 18 '14 at 18:49
00000000
4672619
asked Apr 18 '14 at 18:49
00000000
4672619
asked Apr 18 '14 at 18:49
00000000
4672619
asked Apr 18 '14 at 18:49
00000000
4672619
4672619
Show your connection string....
– Steve
Apr 18 '14 at 18:51
im sorry completely new to database stuff, how do i do that?
– 0000
Apr 18 '14 at 19:03
if it helps the file is on my computer
– 0000
Apr 18 '14 at 19:07
1
The problem is probably due to an incorrect OleDb driver selected by the wizard that builds your connection string. (The string used to connect to your database)
– Steve
Apr 18 '14 at 19:12
4
Right click your connection in the Server Explorer, choose Modify Connection, Click Advanced, look at the line Provider. You should haveMicrosoft.ACE.OLEDB.12.0as provider notMicrosoft.Jet.OLEDB.4.0(the latter cannot recognize database in ACCDB format)
– Steve
Apr 18 '14 at 19:17
|
show 3 more comments
Show your connection string....
– Steve
Apr 18 '14 at 18:51
im sorry completely new to database stuff, how do i do that?
– 0000
Apr 18 '14 at 19:03
if it helps the file is on my computer
– 0000
Apr 18 '14 at 19:07
1
The problem is probably due to an incorrect OleDb driver selected by the wizard that builds your connection string. (The string used to connect to your database)
– Steve
Apr 18 '14 at 19:12
4
Right click your connection in the Server Explorer, choose Modify Connection, Click Advanced, look at the line Provider. You should haveMicrosoft.ACE.OLEDB.12.0as provider notMicrosoft.Jet.OLEDB.4.0(the latter cannot recognize database in ACCDB format)
– Steve
Apr 18 '14 at 19:17
Show your connection string....
– Steve
Apr 18 '14 at 18:51
Show your connection string....
– Steve
Apr 18 '14 at 18:51
im sorry completely new to database stuff, how do i do that?
– 0000
Apr 18 '14 at 19:03
im sorry completely new to database stuff, how do i do that?
– 0000
Apr 18 '14 at 19:03
if it helps the file is on my computer
– 0000
Apr 18 '14 at 19:07
if it helps the file is on my computer
– 0000
Apr 18 '14 at 19:07
1
1
The problem is probably due to an incorrect OleDb driver selected by the wizard that builds your connection string. (The string used to connect to your database)
– Steve
Apr 18 '14 at 19:12
The problem is probably due to an incorrect OleDb driver selected by the wizard that builds your connection string. (The string used to connect to your database)
– Steve
Apr 18 '14 at 19:12
4
4
Right click your connection in the Server Explorer, choose Modify Connection, Click Advanced, look at the line Provider. You should have
Microsoft.ACE.OLEDB.12.0 as provider not Microsoft.Jet.OLEDB.4.0 (the latter cannot recognize database in ACCDB format)– Steve
Apr 18 '14 at 19:17
Right click your connection in the Server Explorer, choose Modify Connection, Click Advanced, look at the line Provider. You should have
Microsoft.ACE.OLEDB.12.0 as provider not Microsoft.Jet.OLEDB.4.0 (the latter cannot recognize database in ACCDB format)– Steve
Apr 18 '14 at 19:17
|
show 3 more comments
2 Answers
2
active
oldest
votes
Your computer is missing Microsoft.ACE.OLEDB.12.0
You can get it from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255
edited Jun 2 '16 at 10:19
Gareth
3,43042755
answered Apr 19 '14 at 17:58
00000000
4672619
1
i tried but i still cannot pick .accd driver.
– Bobby
Jun 13 '17 at 3:20
This still does not solve the problem
– Fandango68
Dec 31 '17 at 4:15
add a comment |
I know this is a bit old but if anyone else has the same problem, this worked for me.
According to your description, I create a sample VB project and try connect to the Access 2016 database and I get the same result with you. Then I try to connect old version of Access database and it is successful.
I find the Provider that used to connect the old version is Microsoft.Jet.OLEDB.4.0. But for Access 2016 database, we should use Microsoft.ACE.OLEDB.12.0. So we need to install Microsoft Access Database Engine 2010 Redistributable and 2007 Office System Driver: Data Connectivity Components, which will help us install and register Microsoft.ACE.OLEDB.12.0 to our local machine.
Then please connect the Access 2016 database with following steps.
Add New Data Source --> database --> Dataset --> New Connection --> Microsoft Access Database File --> select the accdb file -> Click Advanced button to change the Provider. Then click the OK button back to the Add connection windows and Test connection, it will succeed.
answered Nov 13 '18 at 2:42
absentheconabsenthecon
20329
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Your computer is missing Microsoft.ACE.OLEDB.12.0
You can get it from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255
edited Jun 2 '16 at 10:19
Gareth
3,43042755
answered Apr 19 '14 at 17:58
00000000
4672619
1
i tried but i still cannot pick .accd driver.
– Bobby
Jun 13 '17 at 3:20
This still does not solve the problem
– Fandango68
Dec 31 '17 at 4:15
add a comment |
Your computer is missing Microsoft.ACE.OLEDB.12.0
You can get it from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255
edited Jun 2 '16 at 10:19
Gareth
3,43042755
answered Apr 19 '14 at 17:58
00000000
4672619
1
i tried but i still cannot pick .accd driver.
– Bobby
Jun 13 '17 at 3:20
This still does not solve the problem
– Fandango68
Dec 31 '17 at 4:15
add a comment |
Your computer is missing Microsoft.ACE.OLEDB.12.0
You can get it from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255
edited Jun 2 '16 at 10:19
Gareth
3,43042755
answered Apr 19 '14 at 17:58
00000000
4672619
Your computer is missing Microsoft.ACE.OLEDB.12.0
You can get it from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255
edited Jun 2 '16 at 10:19
Gareth
3,43042755
answered Apr 19 '14 at 17:58
00000000
4672619
edited Jun 2 '16 at 10:19
Gareth
3,43042755
edited Jun 2 '16 at 10:19
Gareth
3,43042755
edited Jun 2 '16 at 10:19
Gareth
3,43042755
3,43042755
answered Apr 19 '14 at 17:58
00000000
4672619
answered Apr 19 '14 at 17:58
00000000
4672619
answered Apr 19 '14 at 17:58
00000000
4672619
4672619
1
i tried but i still cannot pick .accd driver.
– Bobby
Jun 13 '17 at 3:20
This still does not solve the problem
– Fandango68
Dec 31 '17 at 4:15
add a comment |
1
i tried but i still cannot pick .accd driver.
– Bobby
Jun 13 '17 at 3:20
This still does not solve the problem
– Fandango68
Dec 31 '17 at 4:15
1
1
i tried but i still cannot pick .accd driver.
– Bobby
Jun 13 '17 at 3:20
i tried but i still cannot pick .accd driver.
– Bobby
Jun 13 '17 at 3:20
This still does not solve the problem
– Fandango68
Dec 31 '17 at 4:15
This still does not solve the problem
– Fandango68
Dec 31 '17 at 4:15
add a comment |
I know this is a bit old but if anyone else has the same problem, this worked for me.
According to your description, I create a sample VB project and try connect to the Access 2016 database and I get the same result with you. Then I try to connect old version of Access database and it is successful.
I find the Provider that used to connect the old version is Microsoft.Jet.OLEDB.4.0. But for Access 2016 database, we should use Microsoft.ACE.OLEDB.12.0. So we need to install Microsoft Access Database Engine 2010 Redistributable and 2007 Office System Driver: Data Connectivity Components, which will help us install and register Microsoft.ACE.OLEDB.12.0 to our local machine.
Then please connect the Access 2016 database with following steps.
Add New Data Source --> database --> Dataset --> New Connection --> Microsoft Access Database File --> select the accdb file -> Click Advanced button to change the Provider. Then click the OK button back to the Add connection windows and Test connection, it will succeed.
answered Nov 13 '18 at 2:42
absentheconabsenthecon
20329
add a comment |
I know this is a bit old but if anyone else has the same problem, this worked for me.
According to your description, I create a sample VB project and try connect to the Access 2016 database and I get the same result with you. Then I try to connect old version of Access database and it is successful.
I find the Provider that used to connect the old version is Microsoft.Jet.OLEDB.4.0. But for Access 2016 database, we should use Microsoft.ACE.OLEDB.12.0. So we need to install Microsoft Access Database Engine 2010 Redistributable and 2007 Office System Driver: Data Connectivity Components, which will help us install and register Microsoft.ACE.OLEDB.12.0 to our local machine.
Then please connect the Access 2016 database with following steps.
Add New Data Source --> database --> Dataset --> New Connection --> Microsoft Access Database File --> select the accdb file -> Click Advanced button to change the Provider. Then click the OK button back to the Add connection windows and Test connection, it will succeed.
answered Nov 13 '18 at 2:42
absentheconabsenthecon
20329
add a comment |
I know this is a bit old but if anyone else has the same problem, this worked for me.
According to your description, I create a sample VB project and try connect to the Access 2016 database and I get the same result with you. Then I try to connect old version of Access database and it is successful.
I find the Provider that used to connect the old version is Microsoft.Jet.OLEDB.4.0. But for Access 2016 database, we should use Microsoft.ACE.OLEDB.12.0. So we need to install Microsoft Access Database Engine 2010 Redistributable and 2007 Office System Driver: Data Connectivity Components, which will help us install and register Microsoft.ACE.OLEDB.12.0 to our local machine.
Then please connect the Access 2016 database with following steps.
Add New Data Source --> database --> Dataset --> New Connection --> Microsoft Access Database File --> select the accdb file -> Click Advanced button to change the Provider. Then click the OK button back to the Add connection windows and Test connection, it will succeed.
answered Nov 13 '18 at 2:42
absentheconabsenthecon
20329
I know this is a bit old but if anyone else has the same problem, this worked for me.
According to your description, I create a sample VB project and try connect to the Access 2016 database and I get the same result with you. Then I try to connect old version of Access database and it is successful.
I find the Provider that used to connect the old version is Microsoft.Jet.OLEDB.4.0. But for Access 2016 database, we should use Microsoft.ACE.OLEDB.12.0. So we need to install Microsoft Access Database Engine 2010 Redistributable and 2007 Office System Driver: Data Connectivity Components, which will help us install and register Microsoft.ACE.OLEDB.12.0 to our local machine.
Then please connect the Access 2016 database with following steps.
Add New Data Source --> database --> Dataset --> New Connection --> Microsoft Access Database File --> select the accdb file -> Click Advanced button to change the Provider. Then click the OK button back to the Add connection windows and Test connection, it will succeed.
answered Nov 13 '18 at 2:42
absentheconabsenthecon
20329
answered Nov 13 '18 at 2:42
absentheconabsenthecon
20329
answered Nov 13 '18 at 2:42
absentheconabsenthecon
20329
answered Nov 13 '18 at 2:42
absentheconabsenthecon
20329
20329
add a comment |
add a comment |
Show your connection string....
– Steve
Apr 18 '14 at 18:51
im sorry completely new to database stuff, how do i do that?
– 0000
Apr 18 '14 at 19:03
if it helps the file is on my computer
– 0000
Apr 18 '14 at 19:07
1
The problem is probably due to an incorrect OleDb driver selected by the wizard that builds your connection string. (The string used to connect to your database)
– Steve
Apr 18 '14 at 19:12
4
Right click your connection in the Server Explorer, choose Modify Connection, Click Advanced, look at the line Provider. You should have
Microsoft.ACE.OLEDB.12.0as provider notMicrosoft.Jet.OLEDB.4.0(the latter cannot recognize database in ACCDB format)– Steve
Apr 18 '14 at 19:17