hi,

i have a database and i created a switchboard. but whenever i exit from the switchboard, an error msg will appear.

msg displayed:

You can't exit microsoft access now.
If you are running the visual basic module, that is using OLE and DDE, you may need to interrupt the module.

what is wrong with my database???

pls advice
nono

The access switchboard will eventuallu crash on you. Do not use it. It will corrupt your database.




Sal

I agree with Sal,
Make a form yourself that has all the buttons you need. Switchboards should ONLY ever be used when there's no other option (for example, if you're mucking around with the Northwind database, or some other db that you have no control over).
Along with SUVs, Access switchboards are the work of the devil
Steven

I am a loud man with a very large hat. This means I am in charge

Guys, are you talking about a pre-canned switchboard that Access provides or are you talking about a user-created switchboard? A user-created switchboard is just what Steven is suggesting when he said
However, he says don't use switchboards. Seems contradictory.

When entering a large program/database with lots of options, you need to start somewhere and it has to be organized. A switchboard is just what the doctor ordered. How else would you do it? You just can't start the database in "the middle of something." Remember, if you code your own stuff and do it well, it should cause no problems.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

The switchborad I create for my users is done with the Tree view control and has a lot of error handling in it. The Ms Access switchbords has bugs in the code (go figure).



Sal

I haven't had problems with switchboards crashing or databases being corrupt. I created a switchboard for one of my databases a while ago and I have not had any problems

Ben Horne
Madison Area Technical College student
-------------------------
I am one of those people that you call "Microsoft Access Freaks". I'm addicted to Access

Greg,
I'm pretty sure you know I meant the inbuilt Switchboard, as created by the Switchboard Manager.
It's not the concept of switchboards I'm averse to, it's the way Microsoft makes them.
I'm all for creating custom "switchboards", but I just generally don't use that term, as most people think that means the inbuilt ones.

Mostly because they're plain ugly, and are only set up in the way Microsoft wants you to set it up. If you want to do anything even remotely different, then the inbuilt switchboards suck.
Sure if your database is for an absolutely stock standard company with absolutely nothing out of the ordinary, then go nuts I say - Use the form/table/report/switchboard/query wizards, use bulky macros, never learn a thing about VBA, don't worry yourself about what Option Explicit means!
But as far as I'm concerned, if your company is NOT Northwind Traders, then learn a little bit about Access, and make something useful.


Steven

I am a loud man with a very large hat. This means I am in charge

Hey, where are the [rant][/rant] tags?! ;)

Actually, I was not aware that Access had its own Switchboard generator. Judging from your comments, am I glad I don't!

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Access does have it's own Switchboard Manager which is used to create a switchbard if there isn't one already defined

Ben Horne
Madison Area Technical College student
-------------------------
I am one of those people that you call "Microsoft Access Freaks". I'm addicted to Access

Steven,

Have you tried customizing any switchboard? You can do this, you know. I've done it countless times so the switchboard would look how I wanted it to

Ben Horne
Madison Area Technical College student
-------------------------
I am one of those people that you call "Microsoft Access Freaks". I'm addicted to Access