Professional Web Applications Themes

updateable query - ASP Components

When I start my Site on localhost (W2003Server, IIS, ASP, VB-DLL), it works fine, when I start the Site from a WinXP-Pro, I get the following error, every time I want to update or insert a record in the access-mdb: -2147467259, -198839259, Operation must use an updateable query., (#ProcNo: 103), ErrorLine: 0, Microsoft JET Database Engine, I have absolut no idea, where to search! Please help tia Georg...

  1. #1

    Default updateable query

    When I start my Site on localhost (W2003Server, IIS, ASP, VB-DLL), it works
    fine, when I start the Site from a WinXP-Pro, I get the following error,
    every time I want to update or insert a record in the access-mdb:

    -2147467259, -198839259, Operation must use an updateable query., (#ProcNo:
    103), ErrorLine: 0, Microsoft JET Database Engine,

    I have absolut no idea, where to search!
    Please help
    tia
    Georg
    Georg Bauer Guest

  2. #2

    Default Re: updateable query

    "Georg Bauer" <GeorgBauerdiscussions.microsoft.com> wrote in message
    news:871BECB0-00D6-459E-A980-28C9B5FFD841microsoft.com...
    > When I start my Site on localhost (W2003Server, IIS, ASP, VB-DLL), it
    works
    > fine, when I start the Site from a WinXP-Pro, I get the following error,
    > every time I want to update or insert a record in the access-mdb:
    >
    > -2147467259, -198839259, Operation must use an updateable query.,
    (#ProcNo:
    > 103), ErrorLine: 0, Microsoft JET Database Engine,
    >
    > I have absolut no idea, where to search!
    > Please help
    > tia
    > Georg
    This worked for me:

    1) Open Control Panel then click Folder Options then scroll to the
    bottom and turn off "Simple File Sharing"

    2) Open Windows Explorer, right-click on the database's folder, click
    Properties, click on the (now revealed) Security tab then select Everyone
    then click the "Write" checkbox the click "Apply".


    McKirahan Guest

  3. #3

    Default Re: updateable query

    Thanks, but it does not work for me...

    I set up a virtual directory in IIS to my bin-directory with
    virtual directory: read- and write-permission
    authentication and accesscontrol: anonymous access disabled
    integrated windows
    authentication enabled
    this directory contains the dll-files and the mdb-database-file
    -----
    Then I selected properties of bin-directory in explorer:
    share this folder enabled
    maximum allowed enabled
    permissions everyone full control enabled
    -----
    This is the code for opening the connection to the mdb:
    Set nwDB.cnn = New ADODB.Connection
    cDB = nwDB.DBPathName & "\" & nwDB.DBName
    With nwDB.cnn
    .ConnectionTimeout = 40
    .CursorLocation = adUseServer
    .Mode = adModeReadWrite
    .Provider = nwDB.DBConnString
    .Open ConnectionString:=cDB, UserID:=nwDB.DBUser, Password:=""
    nwDB.isConnected = True
    DoEvents
    End With
    -----
    This is an example for a sql-statement, which causes the error:
    UPDATE Tbl_Job SET job_inputtime = '27.05.2005', job_validtime =
    '27.05.2005', job_user = 'xy', job_action_id = 4, job_changetext = 'xy',
    jobname = 'xy', job_cpu_id = 123, cssystem_id = 1, jobscript_name =
    'xy.sh', projectuser = '', mandid = '', prodid = '', sapjobid = '', logon =
    'maestro', jobdescript = 'xy', errorcontact = 'xy', abortreact_id = 1,
    outofline_id = 2, ressources = 'xy', job_parm = '', errorhandling = '', misc
    = '', job_state_id = 1, job_deliver_name = '', job_deliver_time = '',
    job_receive_name = '', job_receive_time = '', job_user_bensl = 'xy',
    job_user_timestamp = '21.09.2005 08:24:29', dummy1_id = 0, dummy2_id = 0,
    dummy1 = '', dummy2 = '' WHERE job_id = 'xy' AND version = 1
    -----
    This is the statement to execute the sql:
    Set rs = nwDB.cnn.Execute(cSQL, nCount)
    -----

    The clients are XP, the IIS runs on a W2003Server

    Please help
    tia
    Georg
    Georg Bauer Guest

  4. #4

    Default Updateable Query

    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
    query

    I have been attempting to find information about this for two days now, and I
    am out of time. I have granted permissions on all of the files and sub files.
    I am using XP Professional and I can't make any updating of tables happen. If
    anybody has had experience with this I would really appreciate insites....

    Thanks

    BuddyKing Guest

  5. #5

    Default Re: Updateable Query

    I take it all back. I changed "rights" in all files above the DB and it worked.
    BuddyKing Guest

Similar Threads

  1. What is updateable Query?
    By Arif Çimen in forum ASP.NET Web Services
    Replies: 1
    Last Post: April 21st, 01:30 PM
  2. operation must use updateable query
    By Tomas in forum ASP Database
    Replies: 3
    Last Post: June 4th, 05:08 AM
  3. Operation must use an updateable query.
    By Frustrated in forum ASP Database
    Replies: 16
    Last Post: April 13th, 06:25 PM
  4. Operation must use an updateable query Error
    By Ray P. in forum ASP Database
    Replies: 2
    Last Post: November 30th, 05:14 AM
  5. INSERT error :: Updateable query?
    By jason in forum ASP
    Replies: 6
    Last Post: August 9th, 08:06 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139