Connection String Untuk Access 2000-2003
Standard security
1 | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=; |
With database password
This is the connection string to use when you have an access database
protected with a password using the Set Database Password function in
Access.
1 | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword; |
Workgroup (system database)
1 | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw; |
Workgroup (system database) specifying username and password
1 | Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;User
ID=myUsername;Password=myPassword; |
DataDirectory functionality
1 | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb;User Id=admin;Password=; |
Network Location
1 | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin;Password=; | | | |
source: connectionstrings dot com
Connection String Untuk Access 2007
Standard security
1 | Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False; |
With database password
This is the connection string to use when you have an Access 2007
database protected with a password using the “Set Database Password”
function in Access.
1 | Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword; |
DataDirectory functionality
1 | Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccess2007file.accdb;Persist Security Info=False; |
source: connectionstrings dot com
