ASP - MS Access basic connection

<%
'==============================================
' Test MS Access Connection
' This test can be used on .NET 1.1 and 2.0
' Testing only the connection to the database
' Make sure that the IUSR = Modify on the database
'==============================================

'Dim the variables
Dim dbPath, conObj

'SET THE VARIABLES HERE
dbPath = "c:\accounts\username\wwwroot\sample.mdb"


'create the connection object
set cnn = server.createobject("ADODB.Connection")

'open connection
cnn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="+ dbPath +""

'
'This is where you would do stuff with the database
'

'close the connection and kill the object
cnn.close
Set cnn = Nothing
%>

Test MS Access Connection

If you do not see any errors then the connection was successful