Hi Stephen,
You are undoubtedly using a switchboard created with the switchboard
manager. To verify this, do you have a table named "Switchboard Items"?
The switchboard manager wizard uses late bound ADO code behind the
Switchboard form (Access 2000 and higher). If you have any problems with your
MDAC (Microsoft Data Access Components) installation or ADO is not properly
registered on a PC, then you can run into these types of issues. Personally,
I avoid using the wizard-built switchboard by creating my own unbound
switchboard forms.
Try reregistering ADO. To do this click on Start > Run and enter the
following command:
Regsvr32.exe C:\progra~1\common~1\system\ado\Msado15.dll
Then click on OK.
If you still cannot get the switchboard to function properly, then download
the MDAC Component Checker utility and run it on your PC:
http://support.microsoft.com/?id=307255
Good Luck,
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
I have a database designed in Acces2002 (using 2000 format).
I now have a new computer preloaded with Access2003 ...and every time I try
to open the database I get an error loading a form. The error is on the
switchboard.
Stange thing is that this same Database opens on other PC's running 2003.
I tried compacting and repairing and got no results.