I've been developing (for years ...) an access application with Access 2000: now I'd like to try to distribute it.
I converted the application to access 2007-2016, with access 2016 (front end is .accde/r, with shift disabled at start up, which links - via VBA only - to a back end .accdb protected with pw).
Within Access 2000, I set the start up options as in the image below:
Converting the mdb to accdb everything seems to work fine:
my custom menu bar ('MenuPrincipale') can be now accessed through the add-in tab in the main bar of the converted accde. It works fine, although, using Access 2016, I can't modify anymore items in 'MenuPrincipale' and in the other shortcut menus I've created within Acc2000 (for me it's not a problem: I continue developing in access 2000 format). By the way, I can still make visible or not some items dinamically through VBA7.
The BIG problem (so far the only problem...) is that, when the mdb/mde or the accdb/accde is executed by Access 2016 (also in runtime mode), near to the add-in tab that contains my custom menu bar, there is the little helper 'Tell me what you want to do' (that I profoundly hate...) through which users could easily see back end / front end tables, import data into it, relations (it seems that users could even create relations !), and so on (I didn't have the courage to see what else users could do...).
Does anyone know if that door 'Tell me what you want to do' (let's now call it 'Helper') can be closed/hidden with VBA code?
with sth like:
CommandBars("BarName").Controls(" HelperName ").Visible = False
Now it seems that with a new custom bar created within Access2016 the helper vanishes (fortunately...):
the problem is that I should shift to the accdb format (I certainly will, but not now).
Using only VBA would be a better solution, for me.
Thank you