Microsoft Access 2007和超级用户 [英] Microsoft Access 2007 & Power users

问题描述

我们将MS Access 2007用作数据库，并应支持访问权限受限的用户(超级用户):

We're using MS Access 2007 as our DB and should support users with limited access (power users):

• 该数据库对于所有用户应该是公用的(因此不能位于用户的私有文件夹中)
• 在特定的方向上，我们不允许向所有用户授予R/W权限
• 但是我们需要所有用户都可以使用此数据库.

任何人都可以考虑解决此问题的方法吗? (我只能考虑为这项工作编写服务，但我敢肯定必须有更好的东西)

Can anyone can think on a solution to this issue? (I can only think on writing a service to this job, but I'm sure there must be something better)

推荐答案

您想要将MDB拆分为包含查询，表单，报表，宏和模块的前端MDB，其中仅包含后端MDB中的表和关系. FE被复制到每个网络用户计算机. FE MDB链接到驻留在服务器上的后端MDB中的表.您可以对FE MDB进行更新，并可能将其作为MDE分发给用户.

You want to split the MDB into a Front End MDB containing the queries, forms, reports, macros and modules with just the tables and relationships in the Back End MDB. The FE is copied to each network users computer. The FE MDB is linked to the tables in the back end MDB which resides on a server. You make updates to the FE MDB and distribute them to the users, likely as an MDE.

请参阅"将您的应用分为前端和后端提示"页面以获取更多信息.请参见 Auto FE Updater 下载页面，以使此操作相对轻松.还很好地支持Terminal Server/Citrix.

See the "Splitting your app into a front end and back end Tips" page for more info. See the Auto FE Updater downloads page to make this relatively painless.. The utility also supports Terminal Server/Citrix quite nicely.

现在，我还不太明白为什么您会有第二个项目符号中提到的限制.服务器上必须有一个公用文件夹，在该文件夹中所有用途均具有读/写特权.请更详细地说明这一点.

Now I don't quite understand why you have the restriction mentioned in your second bullet There has to be a common folder on a server somewhere where all usess have R/W privileges. Please explain this in more detail.

这篇关于Microsoft Access 2007和超级用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！