I have a form in an ADP that I want to execute a stored procedure on click
of a command button.
The code behind my command button looks like...
dim cmdUpdate as adodb.command
Set cmdUpdate = New Command
.ActiveConnection = CurrentProject.Connection
.CommandType = adCmdStoredProc
.CommandText = "sp_OutworkerPayments"
Set cmdUpdate = Nothing
MsgBox "Payment made successfully.", vbInformation, Caption
.... my problem is that while this code works on my development machine
(which has the full version of Access 2K) when I package and deploy it to
the end users (with Access 2K runtime) it falls over.
Through a series of message boxes inserted in appropriate places I've worked
out that the error occurs on the .parameters.refresh line but I've no idea
why? especially when it works on other machines with the FULL version of
Are there some more properties of the command object I need to use/set?
Any help will be massively appreciated 'cause this is sending me nutz!