Runtime Error 429 - really stuck!

[Guest_imported]

I am trying to write some VBA to perform some operations on records within one of my tables.

Whenever my procedure tries to run I get the "Runtime 429" activex error. But why do I get this?

Here is a sample:

Dim MyDb As Database
Set MyDb = OpenDatabase("C:\Test.mdb&quot

As soon as it hits the "Set..." line I get the message?
Does anyone know how to resolve this problem or can you give me an example of how you guys normally open up a table using VBA.

Your help is much appreciated!

 

[Nancy2]

You are probably missing your reference to DAO -- in a module, check tools, references

 

[Guest_imported]

Hi Nancy

Thanks for your help with this. I've looked under tools, references and there is a tick in the box "Microsoft DAO 3.51 Object Library". Is there anything else I should be looking for??

 

[Guest_imported]

Hi Nancy

Thanks for your help with this. I've looked under tools, references and there is a tick in the box "Microsoft DAO 3.51 Object Library". Is there anything else I should be looking for??

 

[mikehoot]

Try moving the DAO ref up the order so that it is above the ADO ref.

:-9