Re: Microsoft JET Database Engine error '80040e10'

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

TonnyD wrote:
the statement worked. It brought up the table tblIP
Please quote the message you are replying to. :-)

That tells me that that is not the statement that the error message is
referring to. So I look back at the script and see that you've used
Response.Write to print out the wrong statement. You should put the
Response.Write after the statement that is causing the error:

strSQL="UPDATE tblCount SET " & Request.Form("txtOption") & "
= " & Request.Form("txtOption") & " + 1 WHERE ID = " & ID
Response.Write strSQL

SET rsPoll=adoCon.execute(strSQL)

This is bad. Don't use a recordset to execute a statement that does not
return records. This is how to execute a statement that does not return
records:

adoCon.execute strSQL,,129


Is asppoll something you bought from somebody? Can't you get them to
support it? Hmm, given the quality of the code, I guess that's too much
to expect...

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • RE: Cannot Edit Logion Scripts
    ... remove the script that you would like to edit. ... Please capture a screenshot of the error message received on the client ... Microsoft Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Error in script of Internet Explorer
    ... Uncheck the box to Display a notification about every script error. ... Windows Script 5.6 for Windows 2000 and XP ... Error Message When You Browse the Web: An Error Has Occurred in the Script ... Please reply to the newsgroup so others may benefit. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Script in GPO
    ... Please no e-mails, any questions should be posted in the NewsGroup ... I changed the script back to match it, we would then have the same ... 90% of the user that have now logged on are not get the error message ...
    (microsoft.public.win2000.active_directory)
  • Re: Mircrosofts menu redirector example does not work or is it me.
    ... What specific error message are you getting ... To find the best Newsgroup for FrontPage support see: ... |> Make sure you have copied the script to Notepad before you copied the script to your page ...
    (microsoft.public.frontpage.programming)
  • Re: cannot delete folder
    ... Enquire, plan and execute. ... Please tell the newsgroup how any ... > When I try to delete a folder I get this error message: ...
    (microsoft.public.windowsxp.perform_maintain)