Run-time Error on Start-Up !

[prakashwadhwani]

I have a small app which has been working fine for about 1 year now on
WinXp with Office 2003. All of a sudden without any changes being made
to it, the app is giving an error on startup ... here's the error
description:

Run-time error 429
ActiveX component can't create object

If I copy the same Access app onto another PC, it works fine ! No
error !! I've tried it on 2 different PC's.

I've un-installed & re-installed office 2003, applied SP3 but still
the same problem persists.

Here's the offending code in the form load module:

Private Sub Form_Load()
CurrentDb.Properties("StartupShowDBWindow") = False
'==== Hide the database window ======
'DoCmd.SelectObject acTable, , True
'DoCmd.RunCommand acCmdWindowHide
'====================================
CommandBars.ActiveMenuBar.Enabled = False 'Turn Access' Menu Bar
OFF !!

End Sub
The error is in the 1st line: i.e.
CurrentDb.Properties("StartupShowDBWindow") = False

I'm desperate ... Could someone please help ?

Best Rgds,
Prakash

[ARC]

This is a references problem in your code module. Possibly something you had
previously referenced is no longer on your computer, or has been replaced
with the wrong version. If you open up any code module in your program, then
click Tools, References, you should be able to determine what is missing /
broken. Then you would have to restore the file that is missing from one of
your working computers.

Hope this helps,

<pr*************@gmail.comwrote in message
news:4a**********************************@b1g2000h sg.googlegroups.com...

>I have a small app which has been working fine for about 1 year now on
WinXp with Office 2003. All of a sudden without any changes being made
to it, the app is giving an error on startup ... here's the error
description:

Run-time error 429
ActiveX component can't create object

If I copy the same Access app onto another PC, it works fine ! No
error !! I've tried it on 2 different PC's.

I've un-installed & re-installed office 2003, applied SP3 but still
the same problem persists.

Here's the offending code in the form load module:

Private Sub Form_Load()
CurrentDb.Properties("StartupShowDBWindow") = False
'==== Hide the database window ======
'DoCmd.SelectObject acTable, , True
'DoCmd.RunCommand acCmdWindowHide
'====================================
CommandBars.ActiveMenuBar.Enabled = False 'Turn Access' Menu Bar
OFF !!

End Sub
The error is in the 1st line: i.e.
CurrentDb.Properties("StartupShowDBWindow") = False

I'm desperate ... Could someone please help ?

Best Rgds,
Prakash

[prakashwadhwani]

On May 17, 9:01 pm, "ARC" <[e-mail]:

This is a references problem in your code module. Possibly something you had
previously referenced is no longer on your computer, or has been replaced
with the wrong version. If you open up any code module in your program, then
click Tools, References, you should be able to determine what is missing /
broken. Then you would have to restore the file that is missing from one of
your working computers.

Hope this helps,

<[e-mail] in message

news:4a**********************************@b1g2000h sg.googlegroups.com...

I have a small app which has been working fine for about 1 year now on
WinXp with Office 2003. All of a sudden without any changes being made
to it, the app is giving an error on startup ... here's the error
description:

Run-time error 429
ActiveX component can't create object

If I copy the same Access app onto another PC, it works fine ! No
error !! I've tried it on 2 different PC's.

I've un-installed & re-installed office 2003, applied SP3 but still
the same problem persists.

Here's the offending code in the form load module:

Private Sub Form_Load()
CurrentDb.Properties("StartupShowDBWindow") = False
'==== Hide the database window ======
'DoCmd.SelectObject acTable, , True
'DoCmd.RunCommand acCmdWindowHide
'====================================
CommandBars.ActiveMenuBar.Enabled = False 'Turn Access' Menu Bar
OFF !!

End Sub

The error is in the 1st line: i.e.
CurrentDb.Properties("StartupShowDBWindow") = False

I'm desperate ... Could someone please help ?

Best Rgds,
Prakash

Actually initially dao360.dll was mising - i copied it from another pc
onto this. And then this error msg came up.
I un-installed & re-installed office (No Luck), ran registry mechanic
(No Luck), ran Uniblue Registry Booster (No Luck),
and finally i over-installed windowsXP i.e. from the within windows
environment I inserted the WIndows XP cd & ran the installation.
Naturaly, all my apps, desktop, settings, etc. were preserved as I ran
an Upgrade installation & not a fresh one.

BINGO !!! Now all was ok.

Thought I'd just share it here. If anyone knows any other workaround I
could've used, please feel free to let me know.

Best Rgds,
Prakash.