By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,969 Members | 1,564 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,969 IT Pros & Developers. It's quick & easy.

Retrieving Deleted Switchboard form

P: 3
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
Jul 14 '07 #1
Share this Question
Share on Google+
20 Replies


NeoPa
Expert Mod 15k+
P: 31,347
Try the Tools / Startup panel and see what is set to start on opening the database.
Jul 14 '07 #2

ADezii
Expert 5K+
P: 8,619
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!
Jul 15 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
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)>
Jul 15 '07 #4

missinglinq
Expert 2.5K+
P: 3,532
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)>
Jul 15 '07 #5

P: 3
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"
Jul 16 '07 #6

missinglinq
Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Jul 16 '07 #7

P: 1
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! : )
Jul 31 '09 #8

NeoPa
Expert Mod 15k+
P: 31,347
It's always good to see happy campers :)

Nice work Linq! Another very helpful answer.
Aug 3 '09 #9

ADezii
Expert 5K+
P: 8,619
Nine job also, Linq. Another notch in the olde belt, I imagine that you'll be needing a new one very soon! (LOL)!
Aug 3 '09 #10

missinglinq
Expert 2.5K+
P: 3,532
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)>
Aug 3 '09 #11

ADezii
Expert 5K+
P: 8,619
@missinglinq
Hey Linq, who is this NeoPa character, a new Kid-on-the-Block? (LOL)
Aug 3 '09 #12

NeoPa
Expert Mod 15k+
P: 31,347
@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 ;)
Aug 3 '09 #13

ADezii
Expert 5K+
P: 8,619
@NeoPa
Nice to see you guys are still keeping things going nicely without me ;)
Definitely not the same! Glad to have you back.
Aug 3 '09 #14

NeoPa
Expert Mod 15k+
P: 31,347
@ADezii
Thanks ADezii.

I'm a way from being fully fit, but I'll get on as much as I can.
Aug 3 '09 #15

missinglinq
Expert 2.5K+
P: 3,532
Sorry for your troubles, NeoPa, but glad you're back!

Linq ;0)>
Aug 4 '09 #16

NeoPa
Expert Mod 15k+
P: 31,347
Thanks Linq. I only feel half back (if that) at the moment, but looking forward to fuller involvement again :)
Aug 4 '09 #17

P: 1
Its working.. thanks a lot.. :)
Dec 15 '13 #18

P: 1
@missinglinq
just want to say that it's 2019 and you just saved my butt at an internship! Thank you!
1 Week Ago #19

NeoPa
Expert Mod 15k+
P: 31,347
Good to hear some of these old threads are still providing the help they're there for. Thanks for posting :-)
1 Week Ago #20

twinnyfo
Expert Mod 2.5K+
P: 3,184
Glad this post hepped someone recently, also, as now I have a little trick in case I come across something like this. Sometimes, the simple tricks are the best.

Great little tidbit, Linq!
1 Week Ago #21

Post your reply

Sign in to post your reply or Sign up for a free account.