Forums

ASP

This topic is locked

Operation must use an updateable query.

Posted 13 Jan 2004 22:52:34
1
has voted
13 Jan 2004 22:52:34 Jostein Thomassen posted:
I'm getting this error when trying to update a record in my database.

******************************

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/systemblokk/admin/forhandlere/detaljer2.asp, line 81

******************************

Everywhere I look at the web, I'm told that it's a permition problem, and that I should contact my host.
I have... many times...
And they claim everything to be ok from their side.

I also get this error from premade guestbooks, forums and everything I try to put out on my web-place.

Q: Anyone have a clue if there may be an other alternative to solve this problem...

Q: Is there a way to check if I have the right permitions to update the database?


Theese might be lame questions to ask ... I'm a n00b... hehe <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

Replies

Replied 15 Jan 2004 02:04:19
15 Jan 2004 02:04:19 Marcellino Bommezijn replied:
Replied 15 Jan 2004 23:12:24
15 Jan 2004 23:12:24 Dave Thomas replied:
are you including an "ID" numbered colum in the update?, this will give you errors.


Regards,
Dave

[DWMX 2004] | [FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
Replied 16 Jan 2004 02:04:09
16 Jan 2004 02:04:09 Dan Berdusco replied:
As Far as I know, the ONLY thing that will cause this specific error is incorrect permissions, so your internet research is correct.

The folder that your database is stored in needs to have read, write, and delete permissions applied to it. So, I would be willing to bet that whoever is hosting your site has missed or overlooked something.

I know that this doesn't really solve your problem, but.......

Replied 16 Jan 2004 13:31:01
16 Jan 2004 13:31:01 Dave Thomas replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> As Far as I know, the ONLY thing that will cause this specific error is incorrect permissions<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

sorry but that's not correct.

Regards,
Dave

[DWMX 2004] | [FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]

Reply to this topic