Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access ADP: Problem with Parameters.Refresh (Access 2000 SR-1a)

    I have encountered a problem with an Access Database Project.
    My problem concerns using the cmd.parameters.refresh command. I am trying to execute a stored procedure, passing parameters to it. My code is similar to the following:

    Set cmd = New ADODB.Command
    cmd.ActiveConnection = CurrentProject.Connection
    cmd.CommandText =

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access ADP: Problem with Parameters.Refresh (Access 2000 SR-1a)

    Is this a SQL Server stored proc? Is the same version of SS running on the machine that has the problem?
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access ADP: Problem with Parameters.Refresh (Access 2000 SR-1a)

    Charlotte,

    Yes this is an SQLServer stored procedure. The machine that has the problem is connecting to the same SQLServer, same database as my machine through the Access database project.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mishawaka, Indiana, USA
    Posts
    145
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access ADP: Problem with Parameters.Refresh (Access 2000 SR-1a)

    Do you have any missing references on your user's machine?

  5. #5
    New Lounger
    Join Date
    Jan 2001
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access ADP: Problem with Parameters.Refresh (Access 2000 SR-1a)

    Charlotte,

    I believe I have figured this problem out - though I don't completely understand it. I will try to explain coherently.
    The problem seems to lie in the ADO libraries.
    On my machine
    The MS ActiveX Data Objects 2.6 library has filename msado15.dll size 513 kb
    The MS ActiveX Data Objects 2.5 library has filename msado25.tlb size 80 kb
    On my User's machine,
    The MS ActiveXData Objects 2.5 library has filename msado15dll size 477 kb
    Has no 2.6 library
    When you install the office service pack 1a, the 2.5 libraries install.
    When you install SQL Server the 2.6 libraries install.
    Even though I set the 2.5 as a reference in my computer's version of Access for the project, it does not coincide with the version my user has. I have checked this out on a clean machine. I installed Access, then the Service pack. I ran my adp and got the error. I installed SQL Server on that machine, reran the application and no errors appeared.
    Newer products from Microsoft like Windows XP are now up to a 2.7 version I believe. So we will just have to be careful about keeping our libraries in sync.
    I didn't think the versions would cause this kind of problem, since the reference book I was using used the parameters.refresh using the 2.1 library.
    Thanks for considering this problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •