Provide Ability to Create .accdr runtime files from Access "Save & Publish" module.
One of the biggest problems IT Departments have with desktop Access is security issues. Microsoft can do multiple things to address these concerns. One of the most straight-forward is to make it easier to publish a runtime file. Access application administrators should be able to publish a runtime file as fast as they can publish a .accdb or a .accdt file.
I think what would really cure all ailments is if we could compile Access into an EXE, e.g. VB6.
Scottgem Access MVP since 2007 commented
Frankly, I think this idea is a waste of resources. The main purpose of the accdr is to force a full licensed version of Access to run as if it were in Runtime mode. As such, it is primarily a tool for developers to use to test apps.
There are some advantages to deploying an app as accdr. But in those cases the accdr would be created as an accde first. An accdr is created by using the file rename function. When one is created an accde one simply needs to change the name to accdr and the accde is saved as accdr. So what Michelle wants to accomplish is very doable with the process that currently exists.
George Hepworth commented
Alan has explained this quite well, but it doesn't hurt to add a bit of support.
All you need to do is edit the file name! And all a user has to do to recover the full content of the file is to put the "b" back in place of the "r".
There's no security involved. It's all about the runtime EXPERIENCE.
Alan Cossey commented
A .accdr file is nothing different from any other file apart from one letter in the file suffix. To create a .accdr file you take a .accdb file and change the "b" to an "r". It doesn't help with security at all.
Richard Gump commented
Michelle has a wonderful idea!!!!!