Strange ADE Class module error 
Author Message
 Strange ADE Class module error

I've got a very strange anomally when compiling my ADP to an

I have a class module which I use for getting data in and out of forms, and
within that is a function which starts a ADODB.command, sets the properties,
and a parameter
and executes it. See below (where lngRef is the ID value):

    Set cnn = CurrentProject.Connection
    Set cmd = New ADODB.Command
    Set rst = New ADODB.Recordset
    'set the command object properties
    With cmd
        .CommandType = adCmdStoredProc
        .CommandText = mspSelectRecord
        .ActiveConnection = cnn
    End With
    Set prm = cmd.CreateParameter("prm", adInteger, adParamInput, ,
    cmd.Parameters.Append prm
(mspSelectRecord / lngRecID are properties of the class and evaluate to
proc_Name and a ID value)
The problem seems to occur (I've deduced) at the .Execute line and returns
an ado error of -2147217900.
However this works fine in a ADP but once I compile it to a ADE, it falls
over on te .Execute line.

Help please !!!!!

Alex Stevens, England

Sun, 23 Nov 2003 22:44:38 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Strange ADE Class module error

2. Strange error creating Class Module

3. Class modules 97 - Refering to array within a custom class module

4. Accessing procedures of a class module from another class module

5. Strange Error when using classes in VBS

6. Script Debugger - tracking errors in class modules

7. Error calling Class module, Help

8. Error 451 with tabbed control in class module

9. Error handling outside class modules

10. Error Handling Across Class Module Boundaries

11. Error Handling Across Class Module Boundaries (Ooops Fix)

12. Setup Wizard error: No creatable public class module


Powered by phpBB® Forum Software