ACCESS 2000 Switchboard problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a switchboard in Access 2000. It creates the table that underlies the switchboard, but the actual switchboard is no where to be found. I am using service pack 1 update...do I need to update to jet 4.0 just to get the switchboard function to work? Any ideas?
 
Are you saying that you cannot find the form named "Switchboard"? You can try using the
switchboard manager again to re-create this form. First, rename the table "Switchboard
Items" to anything else, such as "SwitchboardItems" (without a space). Then invoke the
switchboard manager. You should get a message that reads:

"The Switchboard Manager was unable to find a valid switchboard
in this database. Would you like to create one?"

Click Yes. Then click on the Close button. You should now have a form named Switchboard.
Delete the new "Switchboard Items" table. Rename your "SwitchboardItems" table back to
"Switchboard Items". You should have a working switchboard now.

A better idea, in my opinion, is to forget about using the switchboard manager to create
switchboards. Use an unbound form with command buttons and VBA code instead. The command
button wizard can write the necessary code for you if you don't mind wizard generated
code.

Tom
___________________________________


I created a switchboard in Access 2000. It creates the table that underlies the
switchboard, but the actual switchboard is no where to be found. I am using service pack
1 update...do I need to update to jet 4.0 just to get the switchboard function to work?
Any ideas?
 
PS.
I forgot to answer the rest of your question....
do I need to update to jet 4.0 just to get the switchboard function to work?
Click to expand...
By using Access 2000, you are already using JET 4.0. The current service pack level for
JET is SP8, and I definately recommend updating to SP8 if you're not already there. See
the following KB article:

How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
http://support.microsoft.com/?id=239114

I also recommend updating your Access Service Pack to SP2 minimum as well. There are a
lot of problems that you'll avoid encountering if you install the fixes that Microsoft has
made available. SP3 is worth considering if you are not attempting to send bulk e-mail
from within Access using SendObject, since it throws a monkey wrench at automating
Outlook. However, there are better ways of doing this that don't involve using Outlook.

Also, update your operating system to its latest available service packs.

Tom
________________________________________


Are you saying that you cannot find the form named "Switchboard"? You can try using the
switchboard manager again to re-create this form. First, rename the table "Switchboard
Items" to anything else, such as "SwitchboardItems" (without a space). Then invoke the
switchboard manager. You should get a message that reads:

"The Switchboard Manager was unable to find a valid switchboard
in this database. Would you like to create one?"

Click Yes. Then click on the Close button. You should now have a form named Switchboard.
Delete the new "Switchboard Items" table. Rename your "SwitchboardItems" table back to
"Switchboard Items". You should have a working switchboard now.

A better idea, in my opinion, is to forget about using the switchboard manager to create
switchboards. Use an unbound form with command buttons and VBA code instead. The command
button wizard can write the necessary code for you if you don't mind wizard generated
code.

Tom
___________________________________


I created a switchboard in Access 2000. It creates the table that underlies the
switchboard, but the actual switchboard is no where to be found. I am using service pack
1 update...do I need to update to jet 4.0 just to get the switchboard function to work?
Any ideas?
 
Back
Top