All geek questions in one place

Ms-access: when I change the extension to ACCDR, forms / tables disappear

I would like to distribute the front end to some people, and I want to make sure that they are not editing anything in it; however, when I change the extension to ACCDR, it causes all forms and tables to disappear. What settings do I need to change so that they can open forms, but not view them in the design view or make any changes to the forms?

+3
source share
1 answer

The accdr extension puts your Access application in Access "run-time" mode, that is, the end user is not able to see the built-in navigation tools in Access. You will need to provide a navigation mechanism inside the application yourself (for example, a launch form with links to forms \ tables with which you want users to interact).

The accdr extension hides objects from the user, but this does not prevent them from changing the file extension back to accdb and changing your \ objects code.

To completely “block” the application, you need to create an accde file. This prevents the user from opening the form in the design view and making changes.

The following two links provide additional information about file types and how to deploy your application:

Access 2007

2007

+5

Source: https://habr.com/ru/post/1770768/

More articles:


All Articles