VBScript runtime error '800a0006'

Report · Sep 21, 2006

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

Report · Sep 25, 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
>