How do I re-create the switchboard link between front & back ends?

[sueb]

In my front end, I removed a form named simply "Switchboar d", thinking it was left over from an early attempt to make my own switchboard. As a result, opening my database gives me the error "The form name 'Switchboard' is misspelled or refers to a form that doesn't exist."

The switchboard is still intact because I can access it from the Switchboard Manager if I open the database with <shift>double-click, but I don't know how to get the front end to recognize it.

Thanks!

[sueb]

Okay, the kludge I tried that worked was to copy the form "Switchboar d" from a different database that also had a switchboard. This seems lame to me; surely there is a way to re-create the "Switchboar d" from within a front end that has lost it.

[ADezii]

The Switchboard Items Table precisely controls the behavior of the Switchboards themselves. If it is still present, you can manually re-create the Switchboard and restore it to its previous State. You can create a Demo Switchboard with several Options, then look at the HandleButtonCli ck() Routine which will describe the Options in the Switchboard Items Table.

P.S. - I do believe that this problem ws previously solved by missinglinq in the following Thread, Post Number 5:

http://bytes.com/topic/access/answers/677498-retrieving-deleted-switchboard-form

[sueb]

That was really my question: HOW do I manually recreate the Switchboard? And I see in the thread you linked to, that the only save is to essentially do what I did; i.e., make/copy an existing one.

I'm appalled that Access allows the deletion of something so crucial without the ability to get it back, especially since getting it back would seem a trivial function from "inside" the application if the table is still there.

[ADezii]

You can manually recreate the Switchboard, but it requires intimate knowledge of the Switchboard Items Table and the Values contained therein and what they represent. That is why I suggested a look at the HandleClick() Sub-Routine, which reads this Table and manipulates the Values contained in its Fields to dynamically produce various Switchboards based on a single Template. If I have time, I'll post a sample Switchboard Items Table and illustrate how the re-build can occur from there. You will still have to create a simple Switchboard via the Switchboard Manager to generate the basic code needed for it to function.

[NeoPa]

Sorry Sue. That isn't even an answer to the question (but rather a work-around) so I reset it. The Best Answer is there to direct people to a good solution to the problem when they search for it and have limited time.

As for the question, I have a database without a switchboard, and I selected Tools / Database Utilities / Switchboard Manager and it told me I had none, and asked if I wanted one created for me. I didn't want to proceed as I don't want one, but I suspect if you did, you may well get what you need.

Let us know how you get on.