| Article ID: | SFKB0006 |
| Last Reviewed: | August 18, 1997 |
| Applies To: | SPEED Ferret 3.0 (SPEED Ferret for Access 97/VB5) |
Symptoms
SPEED Ferret fails to start, and reports "Run-time error 457: This key is already associated with an element of this collection. Context: sfac80.CommandBars.Load.
Cause
Your database contains two CommandBars having identical names.
Access 97 does not normally allow two CommandBars in the same database to have the same name. It appears, however, that this condition can arise when importing toolbars from an Access 2 database.
Solution
Download the Revision B Update to SPEED Ferret for Access 97. This updated version of SPEED Ferret detects duplicate CommandBar names and notes them in the Inspection Errors log, while continuing to start normally.
How to Eliminate Duplicate CommandBar Names
- Open your Access 97 database.
- Open the View menu and select Toolbars. Then select Customize.
- Review the list of CommandBars and locate the ones with duplicate names.
- Select one of the duplicates and then delete or rename it. (Note: If the Delete and Rename buttons are dimmed, it means that you have selected a built-in toolbar. You can only delete or rename user-defined toolbars.)