when convert Access 97 to Access 2002

Results 1 to 2 of 2

Thread: when convert Access 97 to Access 2002

  1. #1
    Join Date
    Dec 1969

    Default when convert Access 97 to Access 2002

    I have created my database in Access 97, but after I convert the database to Access 2002, my database connection can not work correctly. The erroe message is:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.<BR>/dbresult.asp, line 90<BR><BR>Part of my code related is:<BR><BR>strconn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_privateabsenteeism.mdb")<BR>Set rst = Server.CreateObject("ADODB.Recordset")<BR>......<B R>rsAddRecords.Addnew<BR>......<BR>rsAddRecords.Up date<BR><BR>&#039;Reset server objects<BR>rsAddRecords.close<BR>Set rsAddRecords=Nothing<BR>rst.close<BR>Set rst=Nothing<BR>Set strconn = Nothing<BR><BR>BTW, my code is created in the window 97 too, is it possible after move to the window xp, anything changed in the ODBC?<BR><BR>I really appreciate if someone can help me on this!!!

  2. #2
    Join Date
    Dec 1969

    Default AspFaqs.com, Databases, Errors. (eop)


Posting Permissions

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