Use Of Access 2007 in ACE OLE DB 12.0
In this Article I will explain you about use of access 2007 in OLEDB.
Introduction
In this article we will use Microsoft.ACE.OLEDB.12.0 to connect to older .xls workbooks as well.
Coding
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