Use Of Access 2007 in ACE OLE DB 12.0

In this Article I will explain you about use of access 2007 in OLEDB.
  • 1960


In this article we will use  Microsoft.ACE.OLEDB.12.0 to connect to older .xls workbooks as well.


Code For Security

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Folder\myAccess2007file.accdb;Persist Security Info=False;

With database password

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;

Functionality of DataDirectory

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccess2007file.accdb;Persist Security Info=False;

Remote drives

Driver={Microsoft dBase Driver (*.dbf)};datasource=dBase Files;


You may also want to read these related articles : here

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answer here


More Articles

© 2020 DotNetHeaven. All rights reserved.