Making a switchboard in an Access 2k3 Project

  • Thread starter Thread starter jmillerWV
  • Start date Start date
J

jmillerWV

Hello all,
I am wanting to use an Access 2k3 project tied to an SQL database. I would
like to create a switchboard (as in a regular Access database), but can find
no info on it. When I go to the "Tools" menu the "Switchboard manager" is
greyed out. Can it be done or do I need to look at Access 2k7 or just link a
regular Access DB to the SQL server?
Thanks in advance for your assistance.
 
Access built0in switchboard is not available to ADP, because that
switchboard uses table to store switchboard navigation data. ADP does not
contain database table. You need to design and code your own switchboard in
ADP.
 
The easiest approach is to copy the Switchboard Items table from an mdb into
your SQL Server db. Copy a switchboard form from an mdb into your adp.
Editing the Switchboard Items data by hand is pretty straightforward, or
else you can setup an mdb with everything you want before copying the
Switchboard Items table into SQL Server.
 
Paul,
thanks for the suggestion. I had tried that and it didn't work then I
realized I forgot to place the data in the Switchboard Items Table. It worked
after I put the data in the table.
 
Back
Top