Access Database, Access Denied

Question

Hello, i think this problem is very hard to solve, i'm trying to solve it for 1 week.

I created a Visual Studio 2012 project, and i want to connect a access database to it

When i try to do so, it shows a error message "Access Denied". The steps i make are (add new data source>database>dataset>microsoft database file>...)

When i choose the file and click OK, the error message appears. If i click Test Connection it says Successful.

I asked in VB foruns and they told me to come here, because the problem is with Access.

i have microsoft office 2013 profissional plus.

I did this many times before format my computer, with VS 2012 and office 2010, and it worked, but now it dont.

Thanks

Answer 1

I tried all formats, and the error still shows 😢

Answer 2

Make sure you save the file as a Access 2007 format. Also make sure you don't use any features specific to Access 2013. That might be what is preventing the connection.

Answer 3

but i already did this way many times before, but with access 2010.

Answer 4

Actually I don't think the problem is with Access. I think the problem is how you are connecting the database. And for that you need a Visual Studio expert.