=> Switchboard Manager

  • Thread starter Thread starter Rhonda Fischer
  • Start date Start date
R

Rhonda Fischer

Hello,

In order to speed up my application I am in the process
of copying forms from my Access DB linked to SQL Server
into an Access ADP linked to the same database in
SQL Server.

The problem that I am experiencing is an error msg on
selecting an item from the switchboard. 'There was an
error executing the command' I am unable to view what
that problem might be as the "Switchboard Manager" is
greyed out unable to be selected? Why is this so?

Any suggestions would be much appreciated.

Thank you kindly
Rhonda
 
I would open the DB with the shift-key override. Then
open the VBA Window (Alt f-11) Find the click event then
add a bookmark to see where it is hanging. Perhaps
someting got corruped when migrating over from your
versions of Access.
 
Firstly, the Switchboard is designed for MDBs, NOT ADP so the Switchboard
Manager is disabled if the application is of ADP format.

It is possible to upsize the [Switchboard Items] Table into the MS-SQL
database and copy the Switchboard Form from the existing MDB. However, you
will need to manage these items manually as the Switchboard Manager is
disabled. The code behind the Switchboard Form may not work correctly in
the ADP, either.

Secondly, the Switchboard is a bit too rigid in structure / presentation so
most developers just create their own set of Menu Forms rather than using
the Switchboard.
 
Back
Top