I have an Access 2007 database (.accdb) and I want to lock down settings being changed to it, specifically under menu->Access Options->Current Database->"Display Form"
etc.
I understand you can save it as a .accde which locks down a number of options, but this does not seem to accomplish what I want.
How can I lock down "Access Options->Current Database"?
I'd need to lock down the database per the file, not per user.
DoCmd.ShowToolbar "Ribbon", acToolbarNo
but that's all it said, no idea where to put that.