Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2004

    Unhappy Unanswered: neeeeed heeellllppp in access & ODBC

    sorry about my bad English ....

    Hi all i am a new in this db put i have to find a solution i have a database by access2000 and odbc called "watan" now i have publiched a site it's present data from DB but cannot add any data it's tell me the following ERROR

    ******start error

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
    /forum/register_main.asp, line 953

    ******End error
    so - what is in the line 953 - i will tell u coze i need solution plz..

    ***** code

    'If the admin mode is enabled then add update some extra parts
    If blnAdminMode AND (blnAdmin Or blnModerator) AND strMode = "update" Then

    If lngUserProfileID > 2 Then .Fields("Active") = blnUserActive

    .Fields("Avatar_title") = strMemberTitle
    If isEmpty(lngPosts) = False Then .Fields("No_of_posts") = lngPosts
    'If the user is also the admin then let them update some other parts
    If blnAdmin AND lngUserProfileID > 2 Then
    .Fields("Group_ID") = intUsersGroupID
    End If
    End If
    'Update the database with the new user's details (needed for MS Access which can be slow updating)
    .Update '*****line 953 is here
    'Re-run the query to read in the updated recordset from the database

    ****end code

    in iis in (directory security) -> Edit -> check on annonymus access and set the iuser_username - > and allow iis to control password

    sorry for long message put i want to tell all of u my all problim

    so any one wana help me - answer or add me on msn to talk
    need it soon plz
    best regards
    Attached Thumbnails Attached Thumbnails pic1.bmp  

Posting Permissions

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