Blog: Tag Archives: Code

Access – DSN Less Connection

Posted On:

<%

Set objConn = Server.CreateObject("ADODB.Connection")

'************************************
' Change the path below to reference
' The Location of Your Database
'************************************

strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\inetpub\users\username\databasefolder\databasefilename.mdb"

objConn.connectionstring = strCon
objConn.Open
Set objRS = Server.CreateObject("ADODB.Recordset")
ON ERROR RESUME NEXT
%>