Switchboard Manager runtime error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For some reason Access (2002) returns a run time error if I try and open a
switchboard created by switchboard manager. This is strange because I have
been opening these same files for a year now and am only now getting these
error messages. I suspect it has something to do with a patch or an automatic
download?
Note: If I open Northwinds that works fine, but the switchboard is not
created by the switchboard manager. As soon as I create one in that file I
get the same error.
 
Run time error 430
"Class does not support automation or does not support expected interface."
 
Hummm....error 430 comes up blank on a KB search.

A couple of things to try:

1. Re-register the DAO library. Some instructions on that here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;310937#XSLTH3121121123120121120120

2. Make sure MDAC 2.8 is installed:

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html


in message:
 
Thanks, I'll try that.
If it helps this is the VB script that the debug points to;

Set con = Application.CurrentProject.Connection
stSql = "SELECT * FROM [Switchboard Items]"
stSql = stSql & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" &
Me![SwitchboardID]
stSql = stSql & " ORDER BY [ItemNumber];"
Set rs = CreateObject("ADODB.Recordset")
rs.Open stSql, con, 1 ' 1 = adOpenKeyset
 
Ok,
seems that MDAC did not solve the problem. (Appreciate all the assistance,
thanks).
I see that other users have had similar problems. Proposed solutions have
included;
MDAC: updated and applied successfully
KB833857: update applied successfully

But the following got this message when I tried to install "Expected version
of product not found on system" (I have Access 2002)
KB813617 (Access 2002 runtime)
Office XP SP3 for Access 2002 runtime

Thanks again,
Graeme

Jeff Conrad said:
I would check the MDAC. Previous posts have had this error:

Run-time error 2147024769 (8007007f)
Method 'Connection' of object '_CurrentProject' failed

....the line that gave the problem is
Set con = Application.CurrentProject.Connection

Updating MDAC solved the issue in most cases.
Hopefully, you will have success as well.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:
Thanks, I'll try that.
If it helps this is the VB script that the debug points to;

Set con = Application.CurrentProject.Connection
stSql = "SELECT * FROM [Switchboard Items]"
stSql = stSql & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" &
Me![SwitchboardID]
stSql = stSql & " ORDER BY [ItemNumber];"
Set rs = CreateObject("ADODB.Recordset")
rs.Open stSql, con, 1 ' 1 = adOpenKeyset
Click to expand...
Click to expand...
 
Damn,
was hoping I might avoid that.
But yes, on another system this works fine. They are on Access 2003, but
still, indications are the problem is on my pc. It used to work before....
Will let you know.
Thanks.
 
It gets worse!

I uninstalled Office and re-installed.
Now I get a broken reference (OWC10.DLL version 1.1) followed by the same
runtime error.
 
Hi Graeme,

Try downloading and running the MDAC Component Checker utility. The
wizard-built switchboard uses late bound ADO code. You apparently have a
problem with one or more files that make up the Microsoft Data Access
Components. This could include a missing or corrupted file, or a mismatched
file version. Upgrading MDAC can fix the problem if the appropriate files get
replaced. However, if you were already at MDAC 2.8, then such conditions
would not be rectified.

Component Checker: Diagnose problems and reconfigure MDAC installations
http://support.microsoft.com/?id=307255

By the way, why not just create an unbound switchboard and eliminate the
possibility of this type of error in the future (assuming this is the only
ADO code in your database)?


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

For some reason Access (2002) returns a run time error if I try and open a
switchboard created by switchboard manager. This is strange because I have
been opening these same files for a year now and am only now getting these
error messages. I suspect it has something to do with a patch or an automatic
download?
Note: If I open Northwinds that works fine, but the switchboard is not
created by the switchboard manager. As soon as I create one in that file I
get the same error.
 
Back
Top