Just updated web page that uses Access database.  I now have a database that 
appears to be read only and I have been poking around in XP and cannot get 
back to where I had it with MS 2000 and being able to write data to it.

Here is message
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/i94/SQLaddi94.asp, line 58


I have been researching the web, but so far most to the fixes have
not been in XP yet, has anyone else hit this?
------------------------------------------------

This is in the approximate area of blow up
'sqladdi94.asp

  Set objComm = Server.CreateObject("ADODB.Command")

  objComm.ActiveConnection = strConnect


   objComm.ActiveConnection = strConnect
   objComm.CommandText = "INSERT INTO Members(Fname, lname, callid, class, 
renew) VALUES (  '" & strfname & "', '" & strlname & "' , '" & strcall & "', 
' " & strclass & "', '" & strdate & "')"
   objComm.CommandType = adCmdText
   objComm.Execute intNoOfRecords

  ----------------------------------------------------

Might be something in the way I open it to allow that, any answers 
appreciated, back to the book...

Thanks in advance
Chuck




_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

Make sure that you have write access to the database.
That is the most common occurance of this error :)

Cheers,
Sverrir


Here is message
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/i94/SQLaddi94.asp, line 58

In WindowsXP Explorer, ensure that you do not have simple file sharing
enabled:
(Tools | Folder Options | View - uncheck "enable simple file sharing")

Then, right-click on the folder where the .mdb file is, and ensure that the
IUSR_<machinename> account has the necessary permssions to the folder and
file (RX)

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Charles Mabbott" <aa8vs@m...>
Subject: [access_asp] upgrade from MS 2000 to XP


: Just updated web page that uses Access database.  I now have a database
that
: appears to be read only and I have been poking around in XP and cannot get
: back to where I had it with MS 2000 and being able to write data to it.
:
: Here is message
: Microsoft JET Database Engine (0x80004005)
: Operation must use an updateable query.
: /i94/SQLaddi94.asp, line 58

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~