Switchboard no longer works

[Andy]

I've been busy adding items to a few switchboards, I went to design view of
the switchboard form, didn't do anything and now I get the following error
message when I try to open a switchboard (even if I delete it and recreate
it):

The expression On Open you entered as the even property setting produced the
following error: Object or class does not support the set of events.

* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]
* There may have been an error evaluating the function, event or macro
OK

I have done a compact & repair and it still gives me this message. I have
renamed the switchboard items table and switchboard form and tried to start
over (even on a backup) and it still gives me the message... I'm using Access
2003. Any help would be greatly appreciated. Thanks.

 

[Tom Wickerath]

Hi Andy,

With Access closed, try reregistering your ADO library files. To do this,
click on Start | Run and enter the following command:

Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"

While you have the run dialog open, you might as well try reregistering the
DAO library as well:

Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________