error when trying to connect to access database

  • Thread starter Thread starter MaxJordan91
  • Start date Start date
M

MaxJordan91

Guest
i have read alot of threads about this error and cannot find an explanation.

im using Visual Studio 2010 and trying to access a database made in access 2010, i get this error:

the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine

i have also tried just adding the connectionstring code, but it doesnt work



//opens connection to DB and sets connection string

OleDbConnection connect = new OleDbConnection();

connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=G:\Student.accdb;Persist Security Info=False;";

connect.Open();





i have also tried using this Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center but i get the same error :(



please help me i cannot work out what is causing this error

P.S. i am using legit versions of VS and Access :)

Continue reading...
 
Back
Top