Connection Strings
From Hostek.com Wiki
Revision as of 16:16, 21 November 2012 by Briana (Talk | contribs) (Briana moved page Connection Strings (MS Access) to Connection Strings without leaving a redirect)
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;"