Aseem Nasnodkar
In the zone
I am trying to connet to my access database thro ASP. This code worked earlier on my comp, but after re-installing OS it dsnt. I can read records but cannot add records.
It gives foll error:
My connection strings are as follows:
I dont think anthing is wrong with the code as It worked earlier.
May be the required driver is missing. Please help!
It gives foll error:
Code:
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
My connection strings are as follows:
Code:
<%
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& _
Server.MapPath("/username/database/query.mdb")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open strConnect
Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.open "source",objConn,2,3
objRS.AddNew
objRS("name") = Request.Form("fname")
objRS("email") = Request.Form("femail")
objRS("query") = Request.Form("fquery")
objRS.Update
objRS.close : objConn.close
%>
I dont think anthing is wrong with the code as It worked earlier.
May be the required driver is missing. Please help!