Using Access application with SQL Server 2005.
Application works on Machine 1 with Server 1 but not on Machine 2 with Server 2
One Server 1 I am able to set the value of Parameter by going:
MyCmd.Parameters(1) = 100
On Marchine 2 this triggers and error 3265':ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application.
On Machine 2 the code will work if I use the CreateParameter method.
QUESTION: any way to set things on Machine 2 to allow for the setting parameters simply by using the numeric ordinal?