Re: Item Cannot be Found in Collection
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Sun, 9 Oct 2005 19:05:41 -0400
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:76F1BC4C-4305-402F-9185-AE92BBDFDF6E@xxxxxxxxxxxxxxxx
>>> 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"
.
- References:
- Re: Item Cannot be Found in Collection
- From: Steven Burn
- Re: Item Cannot be Found in Collection
- Prev by Date: Re: Writing and debugging VBS
- Next by Date: Re: How to read data from SQL db and write to a OWC component
- Previous by thread: Re: Item Cannot be Found in Collection
- Next by thread: vbs script for Excel to color rows
- Index(es):
Relevant Pages
|
