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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|