I'm running FP2002 and have an .asp web using an Access database.

Last night, out of the blue, every database results page showed this error:

Microsoft VBScript runtime error '800a0005'

Invalid procedure call or argument: 'Mid'

/_fpclass/fpdbrgn1.inc, line 269

(it appears to be a section stripping out quote marks - this is not
something I've included or changed.)

Once a value is selected from a query-filled dropdown, the error goes away
and the db results are displayed properly. But on entrance to any of those
pages the error displays.

The date on this file and on fpdbrgn2.inc were both yesterday's date, as was
the fbdblib.inc file. I don't know if these dates change everytime the web is
uploaded, but I did not run a Windows or Microsoft program update. I publish
the website almost daily as I'm constantly adding new graphic images and
other data changes.

Important item: I know the fbdblib file was updated yesterday as I've
changed code there to place paragraph breaks in displayed Access memo fields
and they no longer displayed. This happened once before when I ran an Office
update and I had to reinsert the changed code. I fixed this code again and it
fixed the memo field display but had nothing to do with the error.

How do I fix the above? Is it something that can be taken care of by
inserting a default value? I don't have a default value in the database
results and I don't want to display anything until the user selects something
from the dropdown.

"Trillian" <(E-Mail Removed)> wrote in message
newsDA9EC35-76D5-4E2F-A838-(E-Mail Removed)...
> I'm running FP2002 and have an .asp web using an Access database.
>
> Last night, out of the blue, every database results page showed this
> error:
>
> Microsoft VBScript runtime error '800a0005'
>
> Invalid procedure call or argument: 'Mid'
>
> /_fpclass/fpdbrgn1.inc, line 269
>
> (it appears to be a section stripping out quote marks - this is not
> something I've included or changed.)
>
> Once a value is selected from a query-filled dropdown, the error goes away
> and the db results are displayed properly. But on entrance to any of those
> pages the error displays.
>
> The date on this file and on fpdbrgn2.inc were both yesterday's date, as
> was
> the fbdblib.inc file. I don't know if these dates change everytime the web
> is
> uploaded, but I did not run a Windows or Microsoft program update. I
> publish
> the website almost daily as I'm constantly adding new graphic images and
> other data changes.
>
> Important item: I know the fbdblib file was updated yesterday as I've
> changed code there to place paragraph breaks in displayed Access memo
> fields
> and they no longer displayed. This happened once before when I ran an
> Office
> update and I had to reinsert the changed code. I fixed this code again and
> it
> fixed the memo field display but had nothing to do with the error.

I can't tell from your post if this is occuring on your local site on your
PC or on your live site.

>
> How do I fix the above? Is it something that can be taken care of by
> inserting a default value? I don't have a default value in the database
> results and I don't want to display anything until the user selects
> something
> from the dropdown.

http://www.spiderwebwoman.com/resour...cks.asp#return


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

It's on the live site.

Thanks for the tip - but I'd still like to know why this file was changed or
suddenly started behaving this way.

"Kathleen Anderson [MVP - FrontPage]" wrote:

> "Trillian" <(E-Mail Removed)> wrote in message
> newsDA9EC35-76D5-4E2F-A838-(E-Mail Removed)...
> > I'm running FP2002 and have an .asp web using an Access database.
> >
> > Last night, out of the blue, every database results page showed this
> > error:
> >
> > Microsoft VBScript runtime error '800a0005'
> >
> > Invalid procedure call or argument: 'Mid'
> >
> > /_fpclass/fpdbrgn1.inc, line 269
> >
> > (it appears to be a section stripping out quote marks - this is not
> > something I've included or changed.)
> >
> > Once a value is selected from a query-filled dropdown, the error goes away
> > and the db results are displayed properly. But on entrance to any of those
> > pages the error displays.
> >
> > The date on this file and on fpdbrgn2.inc were both yesterday's date, as
> > was
> > the fbdblib.inc file. I don't know if these dates change everytime the web
> > is
> > uploaded, but I did not run a Windows or Microsoft program update. I
> > publish
> > the website almost daily as I'm constantly adding new graphic images and
> > other data changes.
> >
> > Important item: I know the fbdblib file was updated yesterday as I've
> > changed code there to place paragraph breaks in displayed Access memo
> > fields
> > and they no longer displayed. This happened once before when I ran an
> > Office
> > update and I had to reinsert the changed code. I fixed this code again and
> > it
> > fixed the memo field display but had nothing to do with the error.
>
> I can't tell from your post if this is occuring on your local site on your
> PC or on your live site.
>
> >
> > How do I fix the above? Is it something that can be taken care of by
> > inserting a default value? I don't have a default value in the database
> > results and I don't want to display anything until the user selects
> > something
> > from the dropdown.
>
> http://www.spiderwebwoman.com/resour...cks.asp#return
>
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
> blog: http://msmvps.com/spiderwebwoman/category/321.aspx
>
>
>
>
>

Well, since it's on your live site, you might want to check with your host
to see if they've changed anything.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



"Trillian" <(E-Mail Removed)> wrote in message
news:5F13D8D0-E49D-4285-909B-(E-Mail Removed)...
> It's on the live site.
>
> Thanks for the tip - but I'd still like to know why this file was changed
> or
> suddenly started behaving this way.
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> "Trillian" <(E-Mail Removed)> wrote in message
>> newsDA9EC35-76D5-4E2F-A838-(E-Mail Removed)...
>> > I'm running FP2002 and have an .asp web using an Access database.
>> >
>> > Last night, out of the blue, every database results page showed this
>> > error:
>> >
>> > Microsoft VBScript runtime error '800a0005'
>> >
>> > Invalid procedure call or argument: 'Mid'
>> >
>> > /_fpclass/fpdbrgn1.inc, line 269
>> >
>> > (it appears to be a section stripping out quote marks - this is not
>> > something I've included or changed.)
>> >
>> > Once a value is selected from a query-filled dropdown, the error goes
>> > away
>> > and the db results are displayed properly. But on entrance to any of
>> > those
>> > pages the error displays.
>> >
>> > The date on this file and on fpdbrgn2.inc were both yesterday's date,
>> > as
>> > was
>> > the fbdblib.inc file. I don't know if these dates change everytime the
>> > web
>> > is
>> > uploaded, but I did not run a Windows or Microsoft program update. I
>> > publish
>> > the website almost daily as I'm constantly adding new graphic images
>> > and
>> > other data changes.
>> >
>> > Important item: I know the fbdblib file was updated yesterday as I've
>> > changed code there to place paragraph breaks in displayed Access memo
>> > fields
>> > and they no longer displayed. This happened once before when I ran an
>> > Office
>> > update and I had to reinsert the changed code. I fixed this code again
>> > and
>> > it
>> > fixed the memo field display but had nothing to do with the error.
>>
>> I can't tell from your post if this is occuring on your local site on
>> your
>> PC or on your live site.
>>
>> >
>> > How do I fix the above? Is it something that can be taken care of by
>> > inserting a default value? I don't have a default value in the database
>> > results and I don't want to display anything until the user selects
>> > something
>> > from the dropdown.
>>
>> http://www.spiderwebwoman.com/resour...cks.asp#return
>>
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/
>> blog: http://msmvps.com/spiderwebwoman/category/321.aspx
>>
>>
>>
>>
>>