禁用“导入数据”选项 ？ [英] Disable "Import Data" Option ?

问题描述

Hello Guys。

我想知道是否有[VB Code等]的方法，它可以阻止用户将数据从访问数据库导入到另一个数据库。


我有一个数据库，我不希望用户能够将这个数据库的数据（表格，表格，报告，查询，宏，模块等）复制到另一个数据库（使用MS Access的导入选项。


谢谢高级。

Hello Guys.
I would like to know if there is a way [VB Code etc], which can prevent users to import data from an access database to another.

I have a database that I do not want users to be able to copy the data (tables, forms, reports, query, macros, modules etc) of this database to another one (using the import option of MS Access).

Thanks in advanced.

推荐答案

没有人能帮忙吗？没有人知道？

noone can help ? Noone knows ?

没有人能帮忙吗？没人知道 ？

noone can help ? Noone knows ?

我不认为我们在Access数据库中有这个选项，但你可以隐藏表格，表格......然后没有人可以导入你的数据..

- 右键单击​​表格，选择属性，选择隐藏然后确定。

就是帮助。


麦乐

I don''t think we have this option in Access database, but you can hide tables, forms... then nobody could import your data..
- right click on table, select properties, select hidden then ok.
is that help.

Mai Le

要隐藏你必须做的对象麦勒说，你必须去选项 - 视图并在显示下确保隐藏物品 未选中 。


这是否对您有所帮助取决于谁你试图保护你的数据以及它们是多么精明，访问明智。隐藏表的可见性取决于我在上面提到的选项如何设置潜在数据小偷的Access副本！如果他有显示隐藏的对象 选中 ，表格仍然可以导入。


可悲的事实是，访问安全性实际上是为了防止未经授权的用户更改数据库的设计，而不是检索数据。内置的安全性在以前版本的Access中，功能已经非常糟糕，微软完全放弃了它们与v2007。


正如我所说，Access安全性，就像所有安全性一样，取决于谁你正试图抵制。如果它是您组织之外的某个人，那么它们是一般的，非Access特定的事情，可以防止窃取您的数据。但是，如果您关注的人有合法访问您的网络和/或访问应用程序，并且具有任何真正的Access工作知识，那么您的数据的安全性可能通过Acces实际上是不可能的。


我从来没有使用SQL Server或那些类型的后端，并且可能有一些安全方面的事情，你可以使用其中一个。也许我的其中一位囚犯可以帮助你。


祝你好运，欢迎来到字节！


Linq ; 0）>

To hide objects you have to do as Mai Le said and you have to go to Options - Views and under Show make sure the Hidden Objects is unchecked.

Whether or not this will help you depends on who you''re trying to protect your data from and how savvy they are, Access wise. The visibility of the hidden table depends on how the option I mentioned above is set up in the potential data thief''s copy of Access! If he has Show Hidden Objects checked, the table will still be open to being imported.

The sad truth is that Access security is really geared towards preventing non-authorized users from changing the design of the database, not from retrieving data. The built in "security" features has in previous versions of Access has been so poor that Microsoft dropped them altogether with v2007.

As I said, Access security, like all security, really, depends on who you''re trying to secure against. If it''s someone outside of your organization, they are general, non-Access specific things that can be done to prevent the stealing your data. But if the person you''re concerned about has legitimate access to your network and/or Access apps, and has any real working knowledge of Access, security of your data is probably thru Acces is not really possible.

I''ve never worked with SQL Server or those types of back ends, and there may be something, security-wise, that you could do with one of them. Maybe one of my fellow inmates here can help you with that.

Good luck and welcome to bytes!

Linq ;0)>

这篇关于禁用“导入数据”选项 ？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！