Switchboard problem

spcepickle

Registered User.
Local time
Yesterday, 23:15
Joined
Jan 8, 2008
Messages
30
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
 
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
 
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!
 
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.
 

Users who are viewing this thread

Back
Top Bottom