468,113 Members | 2,139 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,113 developers. It's quick & easy.

Retrieving Deleted Switchboard form

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
24 18969
NeoPa
32,023 Expert Mod 16PB
Try the Tools / Startup panel and see what is set to start on opening the database.
Jul 14 '07 #2
ADezii
8,799 Expert 8TB
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
3,532 Expert 2GB
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
3,532 Expert 2GB
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
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
3,532 Expert 2GB
Glad we could help!

Linq ;0)>
Jul 16 '07 #7
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
32,023 Expert Mod 16PB
It's always good to see happy campers :)

Nice work Linq! Another very helpful answer.
Aug 3 '09 #9
ADezii
8,799 Expert 8TB
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
3,532 Expert 2GB
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
8,799 Expert 8TB
@missinglinq
Hey Linq, who is this NeoPa character, a new Kid-on-the-Block? (LOL)
Aug 3 '09 #12
NeoPa
32,023 Expert Mod 16PB
@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
8,799 Expert 8TB
@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
32,023 Expert Mod 16PB
@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
3,532 Expert 2GB
Sorry for your troubles, NeoPa, but glad you're back!

Linq ;0)>
Aug 4 '09 #16
NeoPa
32,023 Expert Mod 16PB
Thanks Linq. I only feel half back (if that) at the moment, but looking forward to fuller involvement again :)
Aug 4 '09 #17
Its working.. thanks a lot.. :)
Dec 15 '13 #18
@missinglinq
just want to say that it's 2019 and you just saved my butt at an internship! Thank you!
Jun 12 '19 #19
NeoPa
32,023 Expert Mod 16PB
Good to hear some of these old threads are still providing the help they're there for. Thanks for posting :-)
Jun 12 '19 #20
twinnyfo
3,638 Expert Mod 2GB
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!
Jun 13 '19 #21
Dear Linq,
you are a lifesaver!!!!!
I will forever be grateful for this!!!!
you just saved months of work!!!!
Thank you for being awesome and smart!!!
ILY
1 Week Ago #22
NeoPa
32,023 Expert Mod 16PB
Well, I have to say we haven't seen him around here since way back at the start of the last decade, so he may not see this. Nevertheless, we always appreciate being told that we, or one of our colleagues, has been of help even nearly fourteen years later.

Long may these old threads continue to help anyone who needs it :-)
1 Week Ago #23
isladogs
225 Expert 128KB
Just to say Linq is definitely still active in a number of forums and still giving out great advice
1 Week Ago #24
NeoPa
32,023 Expert Mod 16PB
In that case tell him I said Hi when you see him :-)
1 Week Ago #25

Post your reply

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

Similar topics

reply views Thread by steve | last post: by
2 posts views Thread by Doug Partridge | last post: by
1 post views Thread by jimwlee | last post: by
3 posts views Thread by Haas C | last post: by
2 posts views Thread by 4Ankit | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.