如果不是管理员，如何限制对MS访问中表的访问 [英] How to Restrict access to tables in MS access if they are not an admin

问题描述

我有一个问题。如果你的用户名=" asdf"我想让我的程序在哪里然后你可以查看MS Access表/查询等。


这甚至可能吗？我有另一个数据库，它总是被阻止，你可以查看它们的唯一方法是保持SHIFT。单击程序时键。我不是那么喜欢。

Hi,

I have a question. I want to make my program where if your username = "asdf" then you can view the MS Access tables/querys etc.

Is this even possible? I have another database where it is always blocked, and the only way you can view them is to hold the "SHIFT" key when clicking on the program. I don''t really like that way though.

推荐答案

我建​​议以适当的方式保护数据库，然后在打开数据库时保护代码，将检查NTID并使数据库窗口可见，如果发现它在可接受用户的列表（或表）中。

I would suggest protecting the database in whichever way seems appropriate, then your code, on opening of the database, would check the NTID and make the Database window visible if it is found to be within a list (or table) of acceptable users.

@NeoPa，找到了如何做到这一点！

@NeoPa, found out how to do it!!!

展开 | 选择 | Wrap | 行号

我认为你不需要任何繁琐的东西。


以下代码m让数据库窗口可见（并选择表单选项卡）：

I don''t think you need anything so cumbersome.

The following code makes the database window visible (and selects the Forms tab) :

展开 | 选择 | Wrap | 行号

这篇关于如果不是管理员，如何限制对MS访问中表的访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！