Hello
I'm fairly new to ASP and am trying to connect to an Access Database using
this code:
Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
Dim strDatabaseType
strDatabaseType = "Access"
'strDatabaseType = "MSDE"
If strDatabaseType = "Access" Then
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\datastores\Movie2000.mdb;" & _
"Persist Security Info=False"
I'm getting the following errror message:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.
Could anyone help?
Thanks
Paul.