philipnaparan

MS Access connection strings MS Access ODBC connection strings

Posted by philipnaparan on 19 September, 2009
2 Comments
This item was filled under [ General Programming ]


MS Access connection strings

MS Access ODBC connection strings


Standard Security:
“Driver= {MicrosoftAccessDriver(*.mdb)};DBQ=C:\App1\Your_Database_Name.mdb;Uid=Your_Username;Pwd=Your_Password;”

Workgroup:
“Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:\App1\Your_Database_Name.mdb; SystemDB=C:\App1\Your_Database_Name.mdw;”

Exclusive “Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\App1\Your_Database_Name.mdb; Exclusive=1; Uid=Your_Username; Pwd=Your_Password;”

MS Access OLE DB & OleDbConnection (.NET framework) connection strings

Open connection to Access database:
“Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\App1\Your_Database_Name.mdb; User Id=admin; Password=”

Open connection to Access database using Workgroup (System database):
“Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\App1\Your_Database_Name.mdb; Jet OLEDB:System Database=c:\App1\Your_System_Database_Name.mdw”

Open connection to password protected Access database:
“Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\App1\Your_Database_Name.mdb; Jet OLEDB:Database Password=Your_Password”

Open connection to Access database located on a network share:
“Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\Server_Name\Share_Name\Share_Path\Your_Database_Name.mdb”

Open connection to Access database located on a remote server:
“Provider=MS Remote; Remote Server=http://Your-Remote-Server-IP; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\App1\Your_Database_Name.mdb”






Rate this topic:
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Popularity: 745 views
Tagged with: [ ]
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Comments on “MS Access connection strings MS Access ODBC connection strings”

  • Jombags101
    Jombags101
    2 October, 2009, 9:09

    Sir good day…How to insert image to MS Access using a connection ADODC for VB 6.0? Because i try all your syntax but it doesn’t work..pls help me..Thank you

  • devsource360
    devsource360
    6 October, 2009, 1:34

    hello, can you please put your code here on how you do the connection setup.

Leave a Comment

« SQL Server connection strings SQL ODBC connection strings
MySQL connection strings MySQL ODBC connection strings »


MS Access connection strings MS Access ODBC connection strings Copyright: You should confirm all information about MS Access connection strings MS Access ODBC connection strings full version edition(freeware/shareware) before downloading or relying on it. Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators or key gen, cd key, hacks, dvd rip is illegal and prevent future development of MS Access connection strings MS Access ODBC connection strings full version edition. Download links are directly from our publisher sites or from the link provided by users, torrent files or links from rapidshare.com, yousendit.com, megaupload.com, netload.in, storage.to or depositfiles.com are not allowed.