Access 2010 Ribbon - Disable Design View?

[jbrumbau]

Hello,

In Access 2010/2007, how do you prevent users from flipping into design view from the ribbon? I do not want to hide the entire ribbon (DoCmd.ShowToolbar "Ribbon", acToolbarNo) or even the "View" part of the "Home" tab because users like being able to flip between Form View and Datasheet View in the forms. It turns out that on our network, if a user inadvertantly clicks Design View, then the database becomes locked to new users until the person who clicked design view closes and reopens the database.

On another website, someone recommended a CustomUI editor, though I don't know where that is for Access 2010, and if it involves an Office 2010 library reference, I'm not sure if it'll work since another office we work with is still using Access 2003 (example: I had to reference Microsoft Excel 11.0 Objects and not the new 14.0 ones when adding excel functionality to our database, they couldn't open it when it referenced 14.0 objects).

I am not sure if I can disable design view with DoCmd.ShowToolbar, and I know for sure Access 2010 doesn't disable ribbon stuff with CommandBars(i) (I did a for loop through every CommandBar and set enabled to false and the ribbon was unaffected).

Please let me know if you know how to disable design view from the ribbon.

Thanks in advance!

[Narender Sagar]

You can go to 'Customize Quick Access toolbar' and then go to 'More Commands' -'Current Database' - then under Ribbon and Toolbar options you can deselect "Allow full menu" and/or "Allow Default Shortcut Menus"
Hope this helps...

[colintis]

Make ACCDE format database can simply remains necessary functions but disable the design view button.

In Access 2010, click File --> Save & Publish, from the screen it shows, the "Save Database As" should be highlighted, then look for "Make ACCDE" on the right.

Make sure you keep the ACCDB database to yourself for modify / update / upgrade purposes, and split the database into Front end and back end, this ensure data stored will not disappear when you replace a newer ACCDE file.

[jbrumbau]

Narender,
Thanks for your reply. I disabled the option "Allow full menus", and though it did get rid of the design view shortcut, it also got rid of the form view and datasheet view toggling which I would like to keep. I did see there were some dropdowns for [Ribbon Name], [Menu Bar], and [Shortcut Menu Bar] in that same options section, are there things I could type into these boxes to just remove the design view from the view toggler?

colintis,
My database is already split into a FE and BE, all tables reside in the BE database. As for making the database an ACCDE, I've seen numerous threads and articles saying not to do it because it is much slower than the MDB format. Not only that but we still have Access 2003 users so the older format is necessary.

Unless there are any other ideas the database will have to remain as is. Thanks for the help though.

[Narender Sagar]

just wondering,...Can you please explain reason why you want user to flip between form view and datasheet view.. may be someone can guide you alternate for that.