Re: ADO Command object in a Loop

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: SA (~fake.address_at_nspm.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 10:50:48 -0400

Dan:

Check the version of the MDAC library that is both on your system and that
is referenced by Access 2000. By default A2K references ADO version 2.1,
which is old and some what buggy in our experience in working with
parameters and properly refreshing the collection etc. If you haven't
downloaded MDAC 2.8 (which contains the ADO libraries), which the latest
version, you can do that from MS' web site. Then update your reference in
the db to ADO 2.7 or greater type library (ADO 2.7 was the base on Windows
Xp, 2.5 on Windows 2000, 2.1 with Access 2000). 

-- 
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
"solex" <solex@nowhere.com> wrote in message 
news:e5jOTDRPEHA.3140@TK2MSFTNGP11.phx.gbl...
>I have a problem with a stored procedure call that occurs in a loop.  I
> initialize both the stored procedure and it's set of parameters before
> entering the loop using the ADO.Command object and its parameter 
> collection.
> Inside the loop I set the parameters and then execute the procedure.
>
> The problem I am having is the parameters do not seem to take on the
> appropriate values after the first iteration of the loop.  The inital 
> values
> of the parameters in the first iteration of the loop are the values that
> remain regardless of how many times the loop is iterated.
>
> The values I am sending differ greatly so it is not a data issue, I ported
> the exact code to VB and executed the command and it works perfectly it
> appears to be a problem within Access 2K VBA.
>
> Has anyone else had this problem?
>
> Regards,
> Dan
>
>
>

Relevant Pages

  • Re: Dim a recordset
    ... I didn't think to put the Microsoft in front of the ADOs. ... reference to ADO, unless I'm not totally sure what I'm looking for. ... Check your References (Tools - References menu in VBA ... libraries that have changed over different versions of ...
    (microsoft.public.access.formscoding)
  • Re: Possible DAO and ADO conflicts
    ... >> I have a legacy application which only has DAO references. ... >> I'm assuming that ADO would be able to create newer versions of Access ... > You can fool around with the order of the libraries in the reference list to ...
    (microsoft.public.vb.database)
  • Re: Recordset errors
    ... have a reference set to the DAO object library, or you have references ... to both the DAO and ADO libraries, with ADO higher in the list of ... declare your objects from these libraries by explicitly ...
    (microsoft.public.access.modulesdaovba)
  • Re: Dim a recordset
    ... ADO should show up as "Microsoft ActiveX Data Objects 2.x Library" ... code, and in the editor I select tools, then references, and I can't see a ... Check your References (Tools - References menu in VBA ... libraries that have changed over different versions of ...
    (microsoft.public.access.formscoding)
  • Re: Which Microsoft ActiveX Data Objects 2.x Library should I reference?
    ... Microsoft ActiveX Data Objects 2.1 Library ... XP and so on have a version of MDAC ... When ADO was introduced and for most of its history it was supported ... One problem was the ADO data access libraries, ...
    (microsoft.public.vb.general.discussion)