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.Prope rties("StartupS howDBWindow") = False
'==== Hide the database window ======
'DoCmd.SelectOb ject acTable, , True
'DoCmd.RunComma nd acCmdWindowHide
'============== =============== =======
CommandBars.Act iveMenuBar.Enab led = False 'Turn Access' Menu Bar
OFF !!
End Sub
The error is in the 1st line: i.e.
CurrentDb.Prope rties("StartupS howDBWindow") = False
I'm desperate ... Could someone please help ?
Best Rgds,
Prakash
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.Prope rties("StartupS howDBWindow") = False
'==== Hide the database window ======
'DoCmd.SelectOb ject acTable, , True
'DoCmd.RunComma nd acCmdWindowHide
'============== =============== =======
CommandBars.Act iveMenuBar.Enab led = False 'Turn Access' Menu Bar
OFF !!
End Sub
The error is in the 1st line: i.e.
CurrentDb.Prope rties("StartupS howDBWindow") = False
I'm desperate ... Could someone please help ?
Best Rgds,
Prakash
Comment