OleDb Connection String For MS Access 2007 Clarification.

[NJC©\(TM\)]

Hello Newsgroup,

Briefly, I have constructed a desktop application using C# 3.5 SP1, with a
Microsoft Access 2007 back end, or more specifically application file. Everything
works well. In my pursuit to (completely) understand the Connection String for
Access 2007, my good friend Google has given me the following information;

Provider=Microsoft.ACE.OLEDB.12.0;
User ID=Admin;
Data Source=Drive:\Path\Database.accdb;
Persist Security Info=False;
Mode=Exclusive;
Extended Properties="";
Jet OLEDB:System Database=Drive:\Path\System.mdw;
Jet OLEDB:Registry Path=Software\Microsoft\Office\12.0\Access\Access Connectivity
Engine;
Jet OLEDBatabase Password=a_password;
Jet OLEDB:Engine Type=6;
Jet OLEDBatabase Locking Mode=0;
Jet OLEDB:Global Partial Bulk Ops=2;
Jet OLEDB:Global Bulk Transaction=1;
Jet OLEDB:New Database Password="";
Jet OLEDB:Create System Database=False;
Jet OLEDB:Encrypt Database=False;
Jet OLEDBon't Copy Locale on Compact=False;
Jet OLEDB:Compact Without Replica Repair=False;
Jet OLEDB:SFP=False;
Jet OLEDB:Support Complex Data=True;

Realising I require a few of these 'tokens' or settings to connect to the
database, I only require Provider, Data Source, and Persist Security Info, for my
application's purposes. I would like to know what values some of the other tokens
my take. For instance what values can;

Mode=
Extended Properties=
Jet OLEDB:Engine Type=
Jet OLEDBatabase Locking Mode=

take?

Thanks and regards,

 

[NJC©\(TM\)]

Thank you kindly Mark, also by your reply I put a particular 'token' into Google
(like Jet OLEDB:Engine Type) and find more info. Thanks again.


| |
| > Mode=
| Mode=Read|Write;
| Mode=Share Deny None;
|
| > Extended Properties=
| When using the Jet driver to interface with other data sources e.g.
| Extended Properties=Excel 12.0;HDR=YES;
| Extended Properties=dBASE IV;UserID=Admin;
|
| > Jet OLEDB:Engine Type=
| Jet OLEDB:Engine Type=4;
| Jet OLEDB:Engine Type=5;
| Jet OLEDB:Engine Type=6;
|
| > Jet OLEDBatabase Locking Mode=
| Jet OLEDBatabase Locking Mode=0;
| Jet OLEDBatabase Locking Mode=1;
|
|
| --
| Mark Rae
| ASP.NET MVP
| http://www.markrae.net
|