A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Switchboard Error



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2004, 01:20 AM
Cheval
external usenet poster
 
Posts: n/a
Default Switchboard Error

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.

  #2  
Old May 27th, 2004, 12:10 PM
Nick Coe \(UK\)
external usenet poster
 
Posts: n/a
Default Switchboard Error

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

"Cheval" wrote in
message ...
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.



  #3  
Old May 27th, 2004, 11:06 PM
Cheval
external usenet poster
 
Posts: n/a
Default Switchboard Error

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

"Nick Coe (UK)" wrote in message
...
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

"Cheval" wrote in
message ...
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.




  #4  
Old May 28th, 2004, 12:00 PM
Nick Coe \(UK\)
external usenet poster
 
Posts: n/a
Default Switchboard Error

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

"Cheval" wrote in message
...
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...

"Nick Coe (UK)"

wrote in message
...
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

"Cheval" wrote in
message ...
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.






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.