Database is readonly

Results 1 to 2 of 2

Thread: Database is readonly

  1. #1
    Luc van Soest Guest

    Default Database is readonly

    When I trie to add a new record to my acces DB I receive this error:<BR>"Error Type:<BR>Microsoft JET Database Engine (0x80040E09)<BR>Cannot update. Database or object is read-only."<BR><BR>code:<BR>&#060;%<BR>set rs = Server.CreateObject("ADODB.Recordset")<BR> Set objConn = Server.CreateObject("ADODB.Connection") <BR> strConn = "Provider=Microsoft.Jet.OLEDB.4.0; " & _<BR> "Data Source=" & Server.Mappath("calendar.mdb") & ";"&_<BR> "USER ID=admin;PASSWORD=;" <BR> objConn.Open strConn<BR> <BR> sql = "SELECT * FROM verlofdagen"<BR> rs.Open sql,objConn,3,3 <BR> <BR> rs.AddNew <BR> rs("persoon_id") = Request.Form("persoon_id")<BR> rs("begindatum") = Request.Form("begindatum")<BR> rs("eindatum") = Request.Form("eindatum")<BR> rs("soort") = Request.Form("soort")<BR> rs("opmerking") = Request.Form("opmerking") <BR> rs.Update<BR> <BR> rs.Close<BR> Set rs = nothing <BR> objConn.Close<BR> Set objConn = nothing<BR><BR>%&#062;<BR>

  2. #2
    Vipul Shah Guest

    Default RE: Database is readonly

    Check the properties of the databse by right clicking in <BR>the explorer.The file may be read only.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts