p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Operation must use an updatable query


Message #1 by "Niklas Nilsson" <niklas.nilsson@f...> on Wed, 19 Jun 2002 09:17:10 +0200
Hello
I'm sure some of you have seen this before like me, but this time it 
seems very weird. The other tables in the database works fine, except 
for this particular table. I can read from it, but not insert or delete. 
An insertion gives me the error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an 
updateable query.
/gastbok/gastbok.asp, line 44

And a delete returns this:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not delete from 
specified tables.
/gastbok/admin/gastbok_admin.asp, line 16

Ideas anyone?

/Niklas Nilsson
_______________________________
AB Favory Design
Kungsgatan 29
745 35 Enk=F6ping
0171-44 44 20
www.favory.se
niklas.nilsson@f...

Message #2 by "Kim Iwan Hansen" <kimiwan@k...> on Wed, 19 Jun 2002 11:34:24 +0200
Hi Niklas,

Take a look at this page:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168

You may also find this one useful:
http://www.skybuilders.com/Documentation/InstallManual2000.html


-Kim


> -----Original Message-----
> From: Niklas Nilsson [mailto:niklas.nilsson@f...]
> Sent: 19. juni 2002 09:17
> To: ASP Databases
> Subject: [asp_databases] Operation must use an updatable query
>
>
> Hello
> I'm sure some of you have seen this before like me, but this time
> it seems very weird. The other tables in the database works fine,
> except for this particular table. I can read from it, but not
> insert or delete. An insertion gives me the error
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC Microsoft Access Driver] Operation must use an
> updateable query.
> /gastbok/gastbok.asp, line 44
>
> And a delete returns this:
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC Microsoft Access Driver] Could not delete from
> specified tables.
> /gastbok/admin/gastbok_admin.asp, line 16
>
> Ideas anyone?
>
> /Niklas Nilsson
> _______________________________
> AB Favory Design
> Kungsgatan 29
> 745 35 Enköping
> 0171-44 44 20
> www.favory.se
> niklas.nilsson@f...
>
>


  Return to Index