Skip to main content
Inspiring
September 21, 2006
Question

VBScript runtime error '800a0006'

  • September 21, 2006
  • 1 reply
  • 634 views
I have a site that is ASP and VBScript with MySQL db and it has been running brilliantly for a number of years, but it has just started to have errors of the following:

Microsoft VBScript runtime error '800a0006'
Overflow
/admin/grantaccess.asp, line 275

Line 275 is this:

rssubsall_first = MM_offset + 1

rssubsall is the name of my recordset.

It is also intermitent, sometimes the error happens and others it doesn't. If I get a page to display correctly, I can click refresh and the exact same page errors - I don't get it!

Any ideas on what is causing this to happen and how I can fix it?

TIA

Mat
This topic has been closed for replies.

1 reply

Inspiring
September 26, 2006
Not sure if this will help but googling the error brought up this answer

Overflow means you ended up with a number too large for the variable type.
The easiest way to determine is output the value prior to attempting to
calculate. You may just need to increase the size of the variable type (like
int to long).

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"matthew stuart" <webforumsuser@macromedia.com> wrote in message
news:eeu03g$r4a$1@forums.macromedia.com...
>I have a site that is ASP and VBScript with MySQL db and it has been
>running
> brilliantly for a number of years, but it has just started to have errors
> of
> the following:
>
> Microsoft VBScript runtime error '800a0006'
> Overflow
> /admin/grantaccess.asp, line 275
>
> Line 275 is this:
>
> rssubsall_first = MM_offset + 1
>
> rssubsall is the name of my recordset.
>
> Any ideas on what is causing this to happen and how I can fix it?
>
> TIA
>
> Mat
>