Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Switchboard Manager (Access 2002)

    I wondered could someone tell me how to restore the Switchboard form when it's been accidently been deleted from the Forms list. I realize the Switchboard Table is still there so it would stand to reason that one could re-create the orginal Switchboard form. Any ideas would be appreciated and thanks in advance for any info. Bob

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access Switchboard Manager (Access 2002)

    Probably the simplest way to do that would be to rename the current Switchboard Table temporarily, create a new Switchboard form using the wizard, and then delete the new Switchboard Table, and then rename the old one back to Switchboard Table.
    Wendell

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Switchboard Manager (Access 2002)

    That's easy:
    1. <LI>Rename the Switchboard Items table to something else, e.g Old Switchboard Items.
      <LI>Select Tools | Database Utilities | Switchboard Manager.
      <LI>Access will note that there is no Switchboard and offer to create a new one. Click Yes.
      <LI>Close the Switchboard Manager immediately.
      <LI>Along with a Switchboard form, a new Switchboard Items table has been created. Delete it.
      <LI>Rename the original table back to Switchboard Items.
    That's it! Takes longer to write down than to do...

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access Switchboard Manager (Access 2002)

    I don't know if you can run the add-in to generate the switchboard if you already have the table there. If it does, then just rename the table and run the add-in which will create a new table. Just delete the new table created and rename the old one back to the correct name.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •