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

Topic

New Reply

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 =

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote