Switchboard problem

[spcepickle]

Hey All - I have a database that is being used on several computers. All computers run XP but some run access 2003 and some run access 2007. The database opens and a switch board comes up. This works on all but one computer (running access 2003) which will not open the switchboard.

When I run the debugger the line that is highlight is:
Set con = Application.CurrentProject.Connection

So far I have tried:
Installing access 2007 - same problem

Installing XP service pack 3 - no difference

Installing MDAC -install file would not run because "all of its features are currently part of windows"

Installing JET 4.0 - also would not run because it was already installed.

I have very little experience with developing databases.

Can anyone help my fix my problem?


Thanks! Amelia

 

[pono1]

Does an error message pop up? Besides posting it here, use it as search criterion on Google...assuming no prompt answer shows up on this forum...

Regards,
Tim

 

[spcepickle]

When I open the database a pop-up appears and says -
Run-time error '429':
ActiveX component can't create object.
When I click debug it highlights the line listed above.
I have tried google which is where I got the idea to update MDAC and JET. So far I can not find any other suggestions.

Thanks!

 

[pono1]

When I Google "Run-time error '429':" I get a lot of results (189,000)... Did you see this one?

http://www.instant-registry-fixes.org/fixing-runtime-error-429-caused-by-automation-server/

I'm just not sure what the problem is...that's why I'm Googling too...

Regards,
Tim

 

[georgedwilkinson]

When I first saw this problem, I thouht it might be a problem with DAO, since the con variable could only be one of 2 types. So I did a quick google on the error you posted and the first result was: http://support.microsoft.com/kb/189366

This almost perfectly describes your problem, assuming that con is a DAO connection object. Read it over and see if it can help to solve the problem. The resolution is almost exactly what I would have suggested, but not quite so elegantly.