Item Cannot be Found in Collection

For over 3 years I have used the same Question and Answer Web Page without
any changes to the page or Access Database.

Three weeks ago I started getting the Item Cannot be Found in Collection
halt after I did a Microsoft update.

The Record has 47 fields that are updated for test surveys by the activities
educators in our school district. 33 Fields are Long Integer, 13 are Byte
Fields and one a Text Field.

Does anyone know what was changed that would all of a sudden give me this
halt.

Thanks for the help in advance!

Granny

Steven
Sat Oct 08 15:31:41 CDT 2005

http://aspfaq.com/show.asp?id=2275

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"GrandMaMa" <GrandMaMa@discussions.microsoft.com> wrote in message
news:76F1BC4C-4305-402F-9185-AE92BBDFDF6E@microsoft.com...
> For over 3 years I have used the same Question and Answer Web Page without
> any changes to the page or Access Database.
>
> Three weeks ago I started getting the Item Cannot be Found in Collection
> halt after I did a Microsoft update.
>
> The Record has 47 fields that are updated for test surveys by the
activities
> educators in our school district. 33 Fields are Long Integer, 13 are Byte
> Fields and one a Text Field.
>
> Does anyone know what was changed that would all of a sudden give me this
> halt.
>
> Thanks for the help in advance!
>
> Granny

GrandMaMa
Sat Oct 08 16:34:02 CDT 2005

Steven:
Thanks for the sugestion.

I tried Set NOCOUNT = ON and I got a syntax error. I am also confused
with with Article # 2159. I have never used Count(Column) before and none of
my programmers manuals show it.

This is my current SQL which I thought was very simple.

rsSurveys.Open "SELECT * FROM SURVEYS", cnnct, 3, 3
There are 47 Fields in the Surveys Table.

Can you give me an example as to what to change? I keep getting syntax
errors in what I have tried. However I am having a hard time with the fact
that this worked for over three years and now fails!

Thanks Again

Granny


"Steven Burn" wrote:

> http://aspfaq.com/show.asp?id=2275
>
> --
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>
> Keeping it FREE!
>
> "GrandMaMa" <GrandMaMa@discussions.microsoft.com> wrote in message
> news:76F1BC4C-4305-402F-9185-AE92BBDFDF6E@microsoft.com...
> > For over 3 years I have used the same Question and Answer Web Page without
> > any changes to the page or Access Database.
> >
> > Three weeks ago I started getting the Item Cannot be Found in Collection
> > halt after I did a Microsoft update.
> >
> > The Record has 47 fields that are updated for test surveys by the
> activities
> > educators in our school district. 33 Fields are Long Integer, 13 are Byte
> > Fields and one a Text Field.
> >
> > Does anyone know what was changed that would all of a sudden give me this
> > halt.
> >
> > Thanks for the help in advance!
> >
> > Granny
>
>
>

BillBarber
Sun Oct 09 12:09:02 CDT 2005

Granny;
I have had trouble with this in the past also. First point of
order is that I have never fiqured out how to get NOCOUNT to work. Why it
seems to be different from system to system I do not know. My friends who
are on Linux systems seem to be able to get it to work.

I hope I am assuming correctly that the number of characters being
transmitted when using Long Integers is increasing. If this is the case then
one of you fields has increased from 2 to 3 didgets, 3 to 4 didgets, 4 to 5
didgets, etc. This has cost out School District a lot of money in the past!
Microsoft has never been clear on how this data is transferred back and forth
from a database. I have gone to their seminars and they seem to be lost when
it comes to Long Integers. If you can change these fields to Integer only, I
am sure it will correct your problem.

If you cannot get back to me. I have never used SELECT COUNT(*)
either, but plan to research it furthur. If you are doing the new SAT
research requests then I am sure you hit that one additional didget that
caused the indicator of column counts to increase by one didget. Check the
field totals by inserting the number 10,000,000,000 in those fields and then
add to that number. If it falis you will have to go to two or three records
to record your data.

For some reason Long Integers will either transmit the highest
possible number or just the characters in those fields. I have played with
this for many days and have never found the pattern, but it only occurs on
Long Integers.

If you cannot go to multiple records try using several Integer
fields. Test each Integer field for its maximum 32,767. When it hits that
number then start incrementing your second Interger field and so on!

Best of Luck,
Coach Barber.

"GrandMaMa" wrote:

> Steven:
> Thanks for the sugestion.
>
> I tried Set NOCOUNT = ON and I got a syntax error. I am also confused
> with with Article # 2159. I have never used Count(Column) before and none of
> my programmers manuals show it.
>
> This is my current SQL which I thought was very simple.
>
> rsSurveys.Open "SELECT * FROM SURVEYS", cnnct, 3, 3
> There are 47 Fields in the Surveys Table.
>
> Can you give me an example as to what to change? I keep getting syntax
> errors in what I have tried. However I am having a hard time with the fact
> that this worked for over three years and now fails!
>
> Thanks Again
>
> Granny
>
>
> "Steven Burn" wrote:
>
> > http://aspfaq.com/show.asp?id=2275
> >
> > --
> > Regards
> >
> > Steven Burn
> > Ur I.T. Mate Group
> > www.it-mate.co.uk
> >
> > Keeping it FREE!
> >
> > "GrandMaMa" <GrandMaMa@discussions.microsoft.com> wrote in message
> > news:76F1BC4C-4305-402F-9185-AE92BBDFDF6E@microsoft.com...
> > > For over 3 years I have used the same Question and Answer Web Page without
> > > any changes to the page or Access Database.
> > >
> > > Three weeks ago I started getting the Item Cannot be Found in Collection
> > > halt after I did a Microsoft update.
> > >
> > > The Record has 47 fields that are updated for test surveys by the
> > activities
> > > educators in our school district. 33 Fields are Long Integer, 13 are Byte
> > > Fields and one a Text Field.
> > >
> > > Does anyone know what was changed that would all of a sudden give me this
> > > halt.
> > >
> > > Thanks for the help in advance!
> > >
> > > Granny
> >
> >
> >

Steven
Sun Oct 09 13:05:37 CDT 2005

Apologies for the delay in responding.

The first thing you need to change is;

"Select * ...."

See: http://aspfaq.com/show.asp?id=2096

With regard to the error you are receiving however, the most common reason
for this occuring is due to the mis-spelling of a column name. For example,
if I wanted to access fldMembers, I'd typically use;

'// Where oDB is my connection to the database
sSQL = "SELECT fldMembers from tblMyTable"
Set fRst = oDB.Execute(sSQL)

Then to write this out to the page;

Response.Write fRst("fldMembers")

If however, I instead wrote this as;

Response.Write fRst("fld_Members")

I would receive an error telling me the item could not be found in the
collection.

The "SELECT * ..." although getting all field names into the collection,
cannot account for any misspelling when outputting it to the browser.

Why your code has worked for 3 years and suddenly broken however, is
something I cannot answer as this will typically not happen unless someone
has changed part of the code.

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"GrandMaMa" <GrandMaMa@discussions.microsoft.com> wrote in message
news:C40BD40C-CF12-46CE-93B3-6FC06BEEEF5F@microsoft.com...
> Steven:
> Thanks for the sugestion.
>
> I tried Set NOCOUNT = ON and I got a syntax error. I am also confused
> with with Article # 2159. I have never used Count(Column) before and none
of
> my programmers manuals show it.
>
> This is my current SQL which I thought was very simple.
>
> rsSurveys.Open "SELECT * FROM SURVEYS", cnnct, 3, 3
> There are 47 Fields in the Surveys Table.
>
> Can you give me an example as to what to change? I keep getting syntax
> errors in what I have tried. However I am having a hard time with the
fact
> that this worked for over three years and now fails!
>
> Thanks Again
>
> Granny
>
>
> "Steven Burn" wrote:
>
> > http://aspfaq.com/show.asp?id=2275
> >
> > --
> > Regards
> >
> > Steven Burn
> > Ur I.T. Mate Group
> > www.it-mate.co.uk
> >
> > Keeping it FREE!
> >
> > "GrandMaMa" <GrandMaMa@discussions.microsoft.com> wrote in message
> > news:76F1BC4C-4305-402F-9185-AE92BBDFDF6E@microsoft.com...
> > > For over 3 years I have used the same Question and Answer Web Page
without
> > > any changes to the page or Access Database.
> > >
> > > Three weeks ago I started getting the Item Cannot be Found in
Collection
> > > halt after I did a Microsoft update.
> > >
> > > The Record has 47 fields that are updated for test surveys by the
> > activities
> > > educators in our school district. 33 Fields are Long Integer, 13 are
Byte
> > > Fields and one a Text Field.
> > >
> > > Does anyone know what was changed that would all of a sudden give me
this
> > > halt.
> > >
> > > Thanks for the help in advance!
> > >
> > > Granny
> >
> >
> >

Bob
Sun Oct 09 18:05:41 CDT 2005

The "SET NOCOUNT ON" suggestion is not relevant for Access databases. It's a
setting that can only be performed in SQL Server.

My guess is that you are running into a reserved keyword situation. It's
hard to be sure, given your use of selstar
(http://www.aspfaq.com/show.asp?id=2096), on top of your failure to show the
line of code that results in the error in your subject line. The problem may
be that a word that was not reserved in the previous version (prior to the
Windows update) has now become reserved due to your update.

But again, this is just a guess.


GrandMaMa wrote:
> Steven:
> Thanks for the sugestion.
>
> I tried Set NOCOUNT = ON and I got a syntax error. I am also
> confused with with Article # 2159. I have never used Count(Column)
> before and none of my programmers manuals show it.
>
> This is my current SQL which I thought was very simple.
>
> rsSurveys.Open "SELECT * FROM SURVEYS", cnnct, 3, 3
> There are 47 Fields in the Surveys Table.
>
> Can you give me an example as to what to change? I keep getting
> syntax errors in what I have tried. However I am having a hard time
> with the fact that this worked for over three years and now fails!
>
> Thanks Again
>
> Granny
>
>
> "Steven Burn" wrote:
>
>> http://aspfaq.com/show.asp?id=2275
>>
>> --
>> Regards
>>
>> Steven Burn
>> Ur I.T. Mate Group
>> www.it-mate.co.uk
>>
>> Keeping it FREE!
>>
>> "GrandMaMa" <GrandMaMa@discussions.microsoft.com> wrote in message
>> news:76F1BC4C-4305-402F-9185-AE92BBDFDF6E@microsoft.com...
>>> For over 3 years I have used the same Question and Answer Web Page
>>> without any changes to the page or Access Database.
>>>
>>> Three weeks ago I started getting the Item Cannot be Found in
>>> Collection halt after I did a Microsoft update.
>>>
>>> The Record has 47 fields that are updated for test surveys by the
>>> activities educators in our school district. 33 Fields are Long
>>> Integer, 13 are Byte Fields and one a Text Field.
>>>
>>> Does anyone know what was changed that would all of a sudden give
>>> me this halt.
>>>
>>> Thanks for the help in advance!
>>>
>>> Granny

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"