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