Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: asp and Access, updateable query error


Message #1 by "Joe Gallagher" <joes_box@h...> on Sat, 17 Feb 2001 08:10:26
Greetings,



I am trying to set up the 'Wrox Classifieds' application on a remote 

server.

However when I try to add a user, I encounter this error:



 'Operation must use an updateable query'.



Thanks,



Joe
Message #2 by Imar Spaanjaars <Imar@S...> on Sat, 17 Feb 2001 13:43:05 +0100
I think you need to post some code. Not everyone here has the book or is 

running the samples.



Usually however, this has to do with the way you open a recordset. If you 

use a cursor type or a lock type that does not allow updating, you'll 

receive this error.

Most likely, you open a recordset with adOpenForwardOnly which will not 

allow an update. But I think we need to see some code to be sure.



Imar





At 08:10 AM 2/17/2001 +0000, you wrote:

>Greetings,

>

>I am trying to set up the 'Wrox Classifieds' application on a remote

>server.

>However when I try to add a user, I encounter this error:

>

>  'Operation must use an updateable query'.

>

>Thanks,

>

>Joe




  Return to Index