Remove Tool Bar Reference

  • Thread starter Thread starter ainow
  • Start date Start date
A

ainow

After converting an existing mdb to an accdb, the tool bars were put into
Add-ins on the ribbon. I could not determine a method to modify the tool
bar/add-ins after the conversion. So I deleted the Add-ins and went a
different route. But now the accdb thinks it is still tied to the tool bar
and gives a message on opening that it cannot file it. I have been unable to
locate where this property is. How do I get this reference removed? Thanks
 
All forms Toolbar and Menu bar properties are blank. Database tools >
Add-ins manager is empty.

Jim
 
The missing Menu Bar was referenced in the original MSAccess 2003 mdb
database (error only occurs when running the database in runtime, does not
occur when in design mode). If I open the mdb in 2007 under Access Options >
Current Database>Ribbon and Toolbar Options there is a dropdown titled “Menu
Bar:â€, changing this to “(default)†corrects the problem in the mdb but that
option is not available in the accdb. How do I remove it from the accdb?

Jim
 
I have previously imported this project to a new accdb in an attempt to solve
this problem. That corrected the tool bar problem, but the combo boxes would
not track input and would not accept typed matching data. The only way to
enter data was to do the dropdown and select. This problem is worse than the
error message on startup. I have never experienced this before, is there a
setting that I missed?

Jim
 
Your recommended settings are my settings.

Here’s a clue, I imported a working from into the new accdb and the combo
boxes worked in design mode, closed the database the reopened in design mode,
the combo boxes do not work. I did the test with 2 different forms, same
results.

I hope this helps.

Jim
 
If I do I am unaware of it. These forms work in the source accdb but do not
work when added to the new accdb. The only problem with the source accdb is
that it is looking for the tool bar, combos work correctly.

What code could be running that would alter the combos behavior?

Jim
 
The problem has been solved. Un-checking SQL Server Compatible (ANSI 92)
“This database†corrected the combo box issue. Checking it caused the
problem to return, un-checking corrected it.

Thanks for your efforts.
Jim
 
Back
Top