vba ms-access:当我将扩展名更改为 ACCDR 表单/表时消失

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/3989910/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 12:13:47  来源:igfitidea点击:

ms-access: when i change extension to ACCDR forms/tables disappear

ms-accessvbams-access-2007

提问by l--''''''---------''''''''''''

i would like to distribute an access front end to some people and i want to make sure that they do not edit anything in it; however when i change the extension to ACCDR it makes all the forms and tables disappear. what settings do i have to change in order for them to be able to open forms but not view them in design view or make any changes to the forms?

我想向某些人分发一个访问前端,我想确保他们不会编辑其中的任何内容;但是,当我将扩展名更改为 ACCDR 时,它会使所有表格和表格消失。我必须更改哪些设置才能让他们能够打开表单但不能在设计视图中查看它们或对表单进行任何更改?

回答by Tim Lentine

The accdr extension puts your Access application into the "runtime" mode of Access, meaning the end user does not have the ability to see the built in navigation tools within Access. You would need to provide the navigation mechanism within the application yourself (for example, a startup form with links to the forms \ tables you want the users to be able to interact with).

accdr 扩展将您的 Access 应用程序置于 Access 的“运行时”模式,这意味着最终用户无法查看 Access 中的内置导航工具。您需要自己在应用程序中提供导航机制(例如,带有指向您希望用户能够与之交互的表单\表格的链接的启动表单)。

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

accdr 扩展对用户隐藏了对象,但它不会阻止他们将文件扩展名更改回 accdb 并修改您的代码 \ 对象。

To completely "lock down" the application you need to create an accde file instead. This prevents the user from being able to open a form in design view and make changes.

要完全“锁定”应用程序,您需要创建一个 accde 文件。这会阻止用户在设计视图中打开表单并进行更改。

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

以下两个链接提供了有关文件类型和部署应用程序方式的其他信息:

Intro to the Access 2007 file format

Access 2007 文件格式简介

Deploy and Access 2007 Application

部署和访问 2007 应用程序