Connection Strings
From Hostek.com Wiki
Revision as of 10:09, 21 November 2012 by Carlb (Talk | contribs) (Created page with "==Connection String Examples== ===Using DSN-less method=== <pre>Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\home\mysite.com\db\myfile.mdb;"</pre> ===Using DS...")
Connection String Examples
Using DSN-less method
Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\home\mysite.com\db\myfile.mdb;"
Using DSN
Conn.Open "MyDSN"
Set Conn = CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\home\mysite.com\db\myfile.mdb;"