Retrieving Deleted Switchboard form

[saurabhpawar]

Hey guys,
I have accidentally deleted the switchboard of the database that I had created. The switchboard form doesn't appear when I click on the Forms section in Access. But heres the deal, when I click the Tools>Database Utilities> Switchboard Manager, the contents of the switch board show up with all the changes . It also allows me to make the changes. I would like to know is there any way to retrieve the switchboard form in the Forms Section or get to it to start on opening the database.

Thank you for the reply
Saurabh

[NeoPa]

Try the Tools / Startup panel and see what is set to start on opening the database.

[ADezii]

Hey guys,
I have accidentally deleted the switchboard of the database that I had created. The switchboard form doesn't appear when I click on the Forms section in Access. But heres the deal, when I click the Tools>Database Utilities> Switchboard Manager, the contents of the switch board show up with all the changes . It also allows me to make the changes. I would like to know is there any way to retrieve the switchboard form in the Forms Section or get to it to start on opening the database.

Thank you for the reply
Saurabh

Sorry Saurabh, I do believe that you are out of luck. What you see when you open the Switchboard Manger, and what you can make changes to, is the Switchboard Items Table which still exists even after the Switchboard Form is long gone. Sorry!

[missinglinq]

A question so elemental we often forget to ask is, do you have a backup copy of your database? If you do you can simply import the switchboard from the backup copy into your current copy. If not, you've learned an important lesson the hard way; always back up! For a database in active development, backing up a very minimum of daily is imperitive! More realistically, backup after you've done any major changes!

Good Luck and Welcome to TheScripts!

Linq ;0)>

[missinglinq]

If you haven't deleted the Switchboard Table from you db, I've figured out how to reconnect it to a switchboard.

Open up a new, blank db.
Create a Switchboard.
Exit this db.
Open your original database.
Goto File - External Data - Import
Import the Switchboard Form (do not import Switchboard Items Table)

You should be set. You'll have to redo any appearance formatting you've done to the Switchboard, but your functionality will be there!

Linq ;0)>

[saurabhpawar]

hey all,

Thank you guys for your help. I will surely keep in mind about the golden rule of Back up. Thank you Linq. Import thing really worked. Thanks for your help. Its helped a lot. Nice getting questions answered on "The Scripts"

[missinglinq]

Glad we could help!

Linq ;0)>

[sbdmytriw]

Linq,

THANK YOU, THANK YOU, THANK YOU!!!!! I didn't know you could delete the one and only one switchboard form - YIKES! This saved my hide! : )

[NeoPa]

It's always good to see happy campers :)

Nice work Linq! Another very helpful answer.

[ADezii]

Nine job also, Linq. Another notch in the olde belt, I imagine that you'll be needing a new one very soon! (LOL)!

[missinglinq]

Multiple notches plus expanding waistline does require a new belt, from time to time! Seriously, it is nice to get feed back when someone benefits from a two year old post like this!

Linq ;0)>

[ADezii]

Multiple notches plus expanding waistline does require a new belt, from time to time! Seriously, it is nice to get feed back when someone benefits from a two year old post like this!

Linq ;0)>

Hey Linq, who is this NeoPa character, a new Kid-on-the-Block? (LOL)

[NeoPa]

Hey Linq, who is this NeoPa character, a new Kid-on-the-Block? (LOL)

I'm away injured for 5 short weeks and this is what I get huh?

Nice to see you guys are still keeping things going nicely without me ;)

[ADezii]

I'm away injured for 5 short weeks and this is what I get huh?

Nice to see you guys are still keeping things going nicely without me ;)

Nice to see you guys are still keeping things going nicely without me ;)

Definitely not the same! Glad to have you back.

[NeoPa]

Definitely not the same! Glad to have you back.

Thanks ADezii.

I'm a way from being fully fit, but I'll get on as much as I can.