I am trying to run access file but I get the
following "runtime error 429
The debugger takes me to the following
' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
Set dbs = CurrentDb()
strSQL = "SELECT * FROM [Switchboard Items]"
strSQL = strSQL & " WHERE [ItemNumber] > 0 AND
[SwitchboardID]=" & Me![SwitchboardID]
strSQL = strSQL & " ORDER BY [ItemNumber];"
Set rst = dbs.OpenRecordset(strSQL)
Can anyone help please.
someone said It may be a conflict with Loutus Smartcenter.
Alex Dybenko - 28 Oct 2003 18:35 GMT
You need to register the DAO dll using regsvr32.
See following KB articles:
ACC: Error Message: ActiveX Component Can't Create Object [Q296205]
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q296205
ACC2000: Error Message: ActiveX Component Can't Create Object
http://support.microsoft.com/support/kb/articles/q296/2/04.asp
ACC2002: Err Msg: "ActiveX Component Can't Create Object"
http://support.microsoft.com/support/kb/articles/q304/1/73.asp

Signature
Alex Dybenko (MVP)
http://Alex.Dybenko.com
> I am trying to run access file but I get the
> following "runtime error 429
[quoted text clipped - 13 lines]
>
> someone said It may be a conflict with Loutus Smartcenter.
MARCELA VARGA - 21 Nov 2003 18:36 GMT
hello
> I am trying to run access file but I get the
> following "runtime error 429
[quoted text clipped - 13 lines]
>
> someone said It may be a conflict with Loutus Smartcenter.