error: Active x component can't create object

[Goha]

---------------------

I get the following error.

run time error '429':
Active x component can't create object

the pocedure that it is in is below

-------------

Private Sub open_database_connection() 'open the connection to access Database (s)
rdoDefaultLoginTimeout = 40 'set the default as 40 sec. --> the error is here
Set EN = rdoEnvironments(0) 'EN.CursorDriver = 1
conn$ = "DSN=picasso;UID=sa;PWD=;DATABASE=blackcar;" 'where to connect
Set cn = EN.OpenConnection("", rdDriverNoPrompt, False, conn$) 'connect
End Sub

 

[teh215]

The syntax you need I believe is:

<Object>.rdoDefaultLoginTimeout = <Value>

http://msdn.microsoft.com/library/d...us/rdo98/html/rdprordoDefaultLoginTimeout.asp

 

[zemp]

Make sure that the active x components are installed on your computer. In this case RDO. Thanks and Good Luck!

zemp

 

[Goha]

zemp - which one would that be?
teh215 - the prograam wass working fine before as is

background:
-----------
I am loading a project from one pc and trying to run it on another. the original pc is my work pc at the office and the second is the pc that i use at home to work from home. I have tried installing vb 4 times what seems to be the issue.

 

[zemp]

Check your project references and see if one is listed as missing. If so then that is the one that you need to install on your computer. Thanks and Good Luck!

zemp

 

[zemp]

Is this related to the problem in thread222-396885 &quot;I am Loading...&quot; If it is then your home computer is missing something that your work computer has installed on it.
Thanks and Good Luck!

zemp