Access 2007 Connection Strings

Access 2007 connection strings
.NET libraries
NONE
OLE DB providers
Microsoft ACE OLEDB 12.0
ODBC drivers
Microsoft Access accdb ODBC Driver
Wrappers and others
.NET Framework Data Provider for OLE DB
.NET Framework Data Provider for ODBC
Microsoft ACE OLEDB 12.0
Standard security
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;
Access 2007
Access 2010
Access 2013
With database password
This is the connection string to use when
you have an Access 2007 – 2013 database
protected with a password using the “Set
Database Password” function in Access.
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database
Password =MyDbPassword;
Some reports of problems with password
longer than 14 characters. Also that some
characters might cause trouble. If you are
having problems, try change password to
a short one with normal characters.
Note! Reports say that a database
encrypted using Access 2010 – 2013
default encryption scheme does not work
with this connection string. In Access; try
options and choose 2007 encryption
method instead. That should make it work.
We do not know of any other solution.
Please get in touch if other solutions is
available!
Access 2007
Access 2010
Access 2013
DataDirectory functionality
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=|DataDirectory|
\myAccessFile.accdb;
Persist Security Info=False;
Access 2007
Access 2010
Access 2013
Network Location
Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\server\share\folder
\myAccessFile.accdb;
Access 2007
Access 2010
Access 2013
↯ Problems connecting? Get answer in the
Access 2007 Q & A forum →
.NET Framework Data Provider for OLE DB
Use an OLE DB provider from .NET
Provider=any oledb provider’s
name;OledbKey1=someValue;OledbKey2=s
omeValue;
See the respective OLEDB provider’s
connection strings options. The .net
OleDbConnection will just pass on the
connection string to the specified OLEDB
provider. Read more here.
Microsoft Access accdb ODBC Driver
Standard Security
Driver={Microsoft Access Driver (*.mdb,
*.accdb)};Dbq=C:\mydatabase.accdb;
Uid=Admin;Pwd=;
Access 2007
Access 2010
Access 2013
Workgroup
Driver={Microsoft Access Driver (*.mdb,
*.accdb)};Dbq=C:\mydatabase.accdb;
SystemDB=C:\mydatabase.mdw;
No changes were made to the .mdw file
format for Office Access 2007. The Office
Access 2007 Workgroup Manager
creates .mdw files that are identical to
those that are created in Access 2000
through Access 2003. The .mdw files that
are created in those earlier versions can be
used by databases in Office Access 2007.
Access 2007
Access 2010
Access 2013
Exclusive
Driver={Microsoft Access Driver (*.mdb,
*.accdb)};Dbq=C:\mydatabase.accdb;
Exclusive=1;Uid=admin;Pwd=;
Access 2007
Access 2010
Access 2013
Enable admin statements
To enable certain programatically admin
functions such as CREATE USER, CREATE
GROUP, ADD USER, GRANT, REVOKE and
DEFAULTS (when making CREATE TABLE
statements) use this connection string.
Driver={Microsoft Access Driver (*.mdb,
*.accdb)};Dbq=C:\mydatabase.accdb;
Uid=Admin;Pwd=;ExtendedAnsiSQL=1;
Access 2007
Access 2010
Access 2013
Specifying locale identifier
Use this one to specify the locale identifier
which can help with non-US formated
dates.
Driver={Microsoft Access Driver (*.mdb,
*.accdb)};Dbq=C:\mydatabase.accdb;
Locale Identifier=2057;Uid=Admin;Pwd=;
The above example uses the en-gb locale
identifier (2057)
Access 2007
Access 2010
Access 2013
.NET Framework Data Provider for ODBC
Use an ODBC driver from .NET
Driver={any odbc driver’s name}
;OdbcKey1=someValue;OdbcKey2=someVa
lue;
See the respective ODBC driver’s
connection strings options. The .net
OdbcConnection will just pass on the
connection string to the specified ODBC
driver. Read more here.
Connect
Access×29
Access 97×20
Access 2000×20
Access 2002×20
Access 2003×20
Access 2007×11
Access 2010×11
Access 2013×11

Posted from WordPress for Android by Arap Meli

Advertisements
Standard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s