Access XP Switchboard error

[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.

 

[Michel Walsh]

Hi,


It seems indeed that Jet is not installed properly. Jet -OLEDB provider
probably does not work anymore from any source (Access, VB, C++, ... ). That
occurred to me, twice, after I installed the wrong update patch of MS SQL
Server. Try repairing the Office installation, if available, or
de-installing then re-installing Office (or, in my case, re-installing the
right patch did solve the problem).



Hoping it may help,
Vanderghast, Access MVP

 

[Cheval]

Yeah, I've uninstalled and re-installed everything but Windows itself.
There's no MS SQL server installed or MSDE, so I'm at the point of a rebuild
is the only other option....

Hi,


It seems indeed that Jet is not installed properly. Jet -OLEDB provider
probably does not work anymore from any source (Access, VB, C++, ... ). That
occurred to me, twice, after I installed the wrong update patch of MS SQL
Server. Try repairing the Office installation, if available, or
de-installing then re-installing Office (or, in my case, re-installing the
right patch did solve the problem).



Hoping it may help,
Vanderghast, Access MVP