How can I open an access database in c#?

Question

I'm trying to open an access database with the extension .accdb so I can read some information from this database. I have no problem doing this, if I use the wizard:

However when try to use code to do this I always get an exception when I try to connect:

From debugging I understood that the exception comes from not having opened the connection. So I open the connection but the the database comes as empty:

I have looked around stack overflow and tried to apply many of the answers to similar questions but they haven't worked. In theory if I can connect through the wizard I should also be able to connect through OleDBConnection object in C#. How can I fix this?

I'm not sure but how about using Provider = Microsoft.Jet.OLEDB.4.0;? — techspider
– techspider, Commented Sep 7, 2016 at 14:42
have you tried to do a simple sql request to it? using OleDbDataReader? — Alex
– Alex, Commented Sep 7, 2016 at 14:42
Please post the code where you instantiate the DataAdapter and set its query string. — John Wu
– John Wu, Commented Sep 7, 2016 at 14:42
That doesn't work for the new extension of access databases .accdb. You have to use 12.0. — João Pinto
– João Pinto, Commented Sep 7, 2016 at 14:43

João Pinto · Accepted Answer · 2016-09-07 15:04:31Z

1

I found the problem. My table name had a space between "Tab_Project Data" and because I didn't use [] it was looking for a table named "Tab_Project" which it couldn't find. So I just had to put "[Tab_Project Data]" inside my query and now it works.

answered Sep 7, 2016 at 15:04

João Pinto

2,0083 gold badges25 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I open an access database in c#?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related