Codes runs in Access 2002 in 2000 mode, but not in Access 2000!!

[JennyPeters]

Why can't I use this code with SQLServer 7 running windows 2000 and Access 2000? It works in Access Xp in 2000 mode on XP Home with SQL7.0. The error states that I am not providing parameters and stops at .Parameters.Refresh. If i remove that line, it then stops at the next line. The error has to be some compatibility problem. What would you suggest?

Dim com As ADODB.Command
Dim rst As ADODB.Recordset

Set com = New ADODB.Command

With com
.ActiveConnection = CurrentProject.Connection
.CommandText = "spInsertIntoTblReportMachines"
.CommandType = adCmdStoredProc
.Parameters.Refresh
.Parameters("@ShiftStart&quot = StartDate
.Parameters("@ShiftEnd&quot = EndDate
Set rst = .Execute
End With

Thanks,

Jenny

 

[xutopia]

Merely speculating here.

Maybe Microsoft isn't aware and we should tell them about this bug. Or maybe they already know about the bug and don't really care since it encourages people with 2000 to upgrade.

Gary

http://www.xutopia.com

Haran
********************************

 

[MaffewW]

it sounds to me like the MDAC on the 2000 machine need updating. I've seen this error before and installing MDAC 2.61 or above fixed it

Matt

Brighton, UK

 

[JennyPeters]

Thanks Matt,

Any idea on how one should go about checking the MDAC version on ones computer?

Thanks!

Jenny

 

[MaffewW]

yeah, open up the registry (run regedit from start/run) and check the data column next to

hkey_local_machine\Software\Microsoft\DataAccess\Version

let us know how you get on

Matt

Brighton, UK

 

[JennyPeters]

Maffew,

Thanks again. I checked with a Win98 System, and the Win200 system, and they are both running 2.50.4430.9. However, my Xp system, in which the code works, says the version is 2.0.0. and the FullInstVer is 2.70.7713.0. Is it the version or the Full Install Version that I should be paying attention to? If it is the latter, then it seems I am running 2.70 in XP, hence the code works there!

Also, how does one upgrade the MDAC? Do I need to buy new software that contains it, or is there a download?

Thanks,
Jenny

 

[JamesLean]

You can download the latest version of MDAC (2.7 sp1) here:

http://www.microsoft.com/downloads/...f2-cae7-493d-b0f3-ae36c570ade8&DisplayLang=en

--James

 

[MaffewW]

Hi Jenny, did upgrading MDAC on the win98 machine do the trick?

Matt

Brighton, UK

 

[JennyPeters]

Maffew,

Just did it yesterday, and it worked like a charm! Thanks so much!

It's interesting how as Access evolves over the years, the components it requires make installs more and more difficult. You've got to have the right Access Version, references, MDAC just for starters...

And it's going to get even worse...

Thanks Again,

Jenny

 

[MaffewW]

glad you got it working

Matt

Brighton, UK