Switchboard Error

  • Thread starter Thread starter Cheval
  • Start date Start date
C

Cheval

I have Office XP SP3 installed on Windows 2000 machine
with full windows updates. When I create a new Access XP
file and then create a new switchboard it, it errors on
the line

Set con = Application.CurrentProject.Connection

with the eror:

Run-time error '430':
Class does not support Automation or does not support
expected interface

I search the net and found out how to create a udl file. I
ran this file and did a Jet 4 OLE connection to this file
yet it also errors:

Test connection failed because of an error in initializing
provider. Class not registered.

So I re-installed the latest versions of the following:
Jet 4 SP 8
MDAC 2.6, 2.7 and 2.8
Office XP

Nothing seems to have helped. Can anyone offer a solution?

Thanks.
 
If you open your code in the vba editor within access, then
look at Tools | References from the menu bar at the top of
the screen, is the reference for ADO 'Microsoft ActiveX Data
Objects x.x Library'
present and checked? (x.x is the version 2.1, 2.7 or
whatever, only check one version).

You really only need to install one version of the MDAC.

If that's not the problem then I'm stuck, sorry.

Nick Coe (UK)
www.alphacos.co.uk
 
Yeah, 2.7. I tried 2.7 refresh 1, no good, 2.8, no good, Office XP, no good,
jet 8Sp1, no good.

I'm stuck as well. This one has be baffled completely!

I don't want to have to do a rebuild of Windows, yet it's looking that
way...

If you open your code in the vba editor within access, then
look at Tools | References from the menu bar at the top of
the screen, is the reference for ADO 'Microsoft ActiveX Data
Objects x.x Library'
present and checked? (x.x is the version 2.1, 2.7 or
whatever, only check one version).

You really only need to install one version of the MDAC.

If that's not the problem then I'm stuck, sorry.

Nick Coe (UK)
www.alphacos.co.uk
 
It doesn't look like a jet prob.

It does look like a library prob. I think you're going to
have to re-install w2k unfortunately, unless someone else
can think of something.

I dug out a notebook I've got w2k and o2k on and tried to
reproduce the problem. I could make it lose references and
go pretty crazy but I couldn't get it to give me that error
message...

It's not something obscure like a COM service or something
not running? Can you compare it against another w2k machine
that's OK and look at the services running etc?

What about your user account permissions? (Said he, grasping
at straws).

Nick Coe (UK)
www.alphacos.co.uk
 
Back
Top