如何设置数据库，以便一个用户只能看到表单而其他用户可以访问所有表单？ [英] How to set up db so one user sees only forms and other user has access to all?

问题描述

我确定这已被问了一百万次，但我似乎无法找到我需要的答案。


我在Access 2007工作。我有一个非常简单的项目，由一个主表，几个查找表，一个交换机表单，两个其他表单（一个数据输入表单和一个查询/搜索表单）和一个报告组成。


我需要设置两个级别的访问权限：


1）输入数据的人只能看到表单和报告，不能访问任何表。如果他们甚至看不到桌子那就太棒了。


2）一个人可以访问所有东西（不是我，因为我把这整件都送到了那些人我正在创造它）。此人可能需要从主表中删除记录或向查找表等添加值。


一个想法是密码保护表。另一个想法是将项目分成（？）到前端/后端。我见过有人提到过这个，并看过NeoPa'的写作（这里）但实际上我不知道怎么做。我不是一个程序员，但可以很好地将事情搞好。


我被告知该项目将在一台计算机上。无法访问SQL Server或任何花哨/复杂的东西。我们并不关心人们黑客攻击数据，只是想避免错误或人们在桌子上戳他们不应该这样做。


想法？思考？建议？

I''m sure this has been asked a million times but I can''t seem to find the answer I need.

I am working in Access 2007. I have a very simple project composed of one main table, several look up tables, one switchboard form, two other forms (one data entry form and one query/search form), and one report.

I need to set this up with two levels of access:

1) people entering data can only see the forms and report, no access to any tables. It would be great if they couldn''t even see the tables.

2) one person with access to everything (not me, since i''m shipping this whole thing off to the folks I''m creating it for). This person may need to delete records from the main table or add values to the look up tables, etc.

One idea is to password protect the tables. Another idea is to split (?) the project into front end/back end. I''ve seen people mention this, and have seen NeoPa''s write up (here) but in reality I have no idea how to do either. I''m not a coder, but can hack things together fairly well.

I''m told the project will be on one computer. There is no access to SQL Server or anything fancy/complicated. We''re not concerned with people hacking the data, just want to avoid mistakes or people poking at tables they shouldn''t.

Ideas? Thoughts? Advice?

推荐答案

我建​​议您在数据库窗口不可见的模式下启动数据库，但主控制表单（可能是交换机）会自动启动。


目前尚不清楚你将如何设想确定哪个用户是当前的运营商，但我会在关闭主表单时执行代码来检查用户，如果他们被允许然后继续显示数据库，而如果他们不是它将关闭数据库本身。


这听起来像它适合吗？这对你来说足够安全吗？

I suggest you have the database start in a mode where the database window is not visible, but your main controlling form (could be switchboard) starts automatically.

It''s not clear yet how you would envisage determining which user is the current operator, but I would have code that executes when the main form is closed that checks the user, if they are allowed then proceed to show the database, whereas if they are not it would close the database itself.

Does this sound like it would suit? Is this secure enough for you?

是的，我想是的。所以基本上当你启动数据库（双击文件名）是第一个显示要求输入密码的窗口时？或类似的东西？


如何隐藏数据库窗口？还是密码保护呢？我在这方面有点不清楚。

Yes I think so. So basically when you launch the database (double click on the file name) is the first window that shows up something that asks for a password? Or something similar?

How do I hide the database window? Or password protect it? I''m a little unclear on this part.

这个怎么样？将数据库拆分为前端和后端。将前端更改为accde文件。将accde重命名为accdr，使其成为运行时文件。


accdr文件位于数据输入人员可以启动它的主要位置。 accdb_be（后端）文件驻留在同一台计算机上的隐藏位置，因此数据输入人员不知道它在哪里并且不打开它但是数据库管理员可以启动它以对表进行更改。


任何人都认为这有什么问题？

How about this? Split the database into front end and back end. Change the front end to an accde file. Rename the accde to accdr so it is a run time file.

The accdr file resides in a main location where data entry folk can launch it. The accdb_be (back end) file resides in a hidden location on the same computer so the data entry folks don''t know where it is and won''t open it but the database admin person can launch it to make changes to the tables.

Anyone see anything wrong with this?

这篇关于如何设置数据库，以便一个用户只能看到表单而其他用户可以访问所有表单？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！