Automation error (Error 440) 
Author Message
 Automation error (Error 440)

Access97 with attached tables from Access2.

A Sub routine - that has worked fine for months! - has suddenly started
resulting the following error message:

Compile Error
Automation error (Error 440)

The compile error stops at a 'Dim tblNAME  as TableDef' declaration.

I am stumped !!!  Any help would be much appreciated.

Many thanks in anticipation

JJ



Sun, 11 Aug 2002 03:00:00 GMT  
 Automation error (Error 440)
Is there a Missing Reference listed under Tools | References? Can you
reestablish the links from a new db?

 -- Dev


: Access97 with attached tables from Access2.
:
: A Sub routine - that has worked fine for months! - has suddenly started
: resulting the following error message:
:
: Compile Error
: Automation error (Error 440)
:
: The compile error stops at a 'Dim tblNAME  as TableDef' declaration.
:
: I am stumped !!!  Any help would be much appreciated.
:
: Many thanks in anticipation
:
: JJ
:
:



Sun, 11 Aug 2002 03:00:00 GMT  
 Automation error (Error 440)
Yep !  Thanks for your help.

Quote:
> Is there a Missing Reference listed under Tools | References? Can you
> reestablish the links from a new db?

>  -- Dev



> : Access97 with attached tables from Access2.
> :
> : A Sub routine - that has worked fine for months! - has suddenly started
> : resulting the following error message:
> :
> : Compile Error
> : Automation error (Error 440)
> :
> : The compile error stops at a 'Dim tblNAME  as TableDef' declaration.
> :
> : I am stumped !!!  Any help would be much appreciated.
> :
> : Many thanks in anticipation
> :
> : JJ
> :
> :



Tue, 13 Aug 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Compilation error: Automation Error (Error 440)

2. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

3. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

4. Automation Error, Error 440 !!

5. Automation error (Error 440)

6. Automation Error Error 440

7. Help: error 440 automation error

8. Error 440, Automation Error

9. Error 440, Automation Error

10. Need some help to trace Automation Error (error 440)?

11. Can't compile my source now!! Getting Automation error (Error 440)

12. Can't compile my source now!! Getting Automation error (Error 440)

 

 
Powered by phpBB® Forum Software