Can’t View Switchboard Items in Access 2000 RT

Topic

New Reply

On one or two pc’s in the plant where I have installed the run-time version, I try to open the database (converted from 97 to 2k), and only one of the buttons on the switchboard is visible, and none of the text that is on the switchboard. The pc’s in question have Win98 Second Edition, Internet Explorer 5x. I checked the references after going into a code module, and they are the same as in other databases that I have. I can go into the same database on a machine I have in my dept., and it will work okay. I did use the same installation package that I have for all other pc’s in the plant. I am using the SR-1 for the Devloper’s Edition. Any ideas? Thank you!

Reply | Quote

Replies

Access Runtime for the most part will allow normal functionality of Access DB’s. However there are cases directly related to use of the Switchboard Manager to develop the application switchboard, where the application will not operate properly in Runtime. I have been down this path several times myself.

There are two solutions: you will either need to add the switchboard manager “add-in” onto the PC’s with runtime, or the easier solution to save future hassles, is to convert the switchboard buttons and labels over to VB or macro driven. Change them over from the current =option value that relies on the underlying Switchboard table to make them work.

This should fix your runtime problem.

Reply | Quote

I did convert the buttons to being activated via macros, but I did use the switchboard manager to set it up (brand new switchboard), in Access 2000. What I don’t get is why it works some of the time, and not others. What file(s) are required for the switchboard manager? Thanks for the help.

Reply | Quote

Make sure you delete all of the filtering events found in the Form properties under the OnOpen, and OnUpdate properties. These events still cause the form to “look” for the options table.

Reply | Quote

It will work on machines that have Access 2000 installed and fail on those that don’t if it follows the normal pattern for runtime problems. Not all menu choices are available in runtime either, so I generally build my own switchboards and commandbar code for runtime applications.

Reply | Quote