MS Access 用户可以输入数据但不能修改数据
我正在尝试创建一个 Access 数据库，该数据库仅允许用户通过表单输入新数据，但输入后不会修改该记录（或其余数据）。然后，数据将受到保护，所有进一步的报告和查询将由具有高级权限的另一个用户完成。
我得出的结论是，使用 Access 无法做到这一点，有人向我提出了一个简单的解决方案，那就是通过 Excel 中的表单输入数据，该表单会将信息输入到 Access 文件中。
这可能吗？如何 ？还有更好的想法吗？
谢谢， 桑托斯
I am trying to create an Access database that will only allow a user to enter new data through a form, but not modify that record (or the rest of the data) once it is entered. The data will then be protected and all further reports and queries will be done by another user with superior rights.
I have come to the conclusion that it is not possible to do this with Access and a simple solution has been proposed to me, and that is to enter the data through a form in Excel which will feed the information into an Access file.
Is that possible ? How ? Any better ideas ?
Thanks,
Santos
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以按照建议设置表单属性，以限制用户可以使用该表单执行的操作。 （另一种可能性是“数据输入”属性...将其设置为“是”将阻止他们在表单中显示以前的数据。）
但是，如果您的目标更广泛（“仅允许用户通过表单输入新数据”） ），您需要阻止他们在数据表视图中打开表、在数据表视图中打开可编辑查询等。
您可以将应用程序分发为 MDE 或 ACCDE 格式数据库并锁定用户界面，以便他们只能访问您提供的那些功能您的表单和自定义菜单（或 2007 年或 2010 年的功能区）。
Access 还提供 MDB 数据库格式的 ULS（用户级安全性）。较新的 ACCDB 格式不支持 ULS ...但 Access 2007 和 2010 仍然可以使用 MDB 格式数据库。缺点是 ULS 的设置有点繁琐，而且不太安全。如果安全性对于您的应用程序很重要，请考虑将数据存储在更安全的数据库中，例如 SQL Server。
我会选择其中任何一个选项，而不是创建 Excel 电子表格来将数据输入到 Access 数据库中。
You can set form properties as suggested to limit what a user can do with that form. (Another possibility is the "Data Entry" property ... setting it to Yes would prevent them from displaying previous data in the form.)
However, if your goal is broader ("only allow a user to enter new data through a form"), you need to prevent them from opening tables in datasheet view, editable queries in datasheet view, etc.
You can distribute your application as an MDE or ACCDE format database and lock down the user interface so they can only access those features you provide with your forms and custom menus (or ribbons in 2007 or 2010).
Access also offers ULS (user level security) in the MDB database format. ULS is not supported in the newer ACCDB format ... but Access 2007 and 2010 can still use MDB format databases. The drawbacks are that ULS is kind of fiddly to set up and not very secure. If security is important for your application consider storing the data in a more securable database such as SQL Server.
I would choose any of those options over creating an Excel spreadsheet for data entry into an Access database.
您应该能够仅允许使用基于表的表单进行数据输入（尽管出于各种原因，我会使用基于表查询的表单） - 只需将管理删除和修改的属性设置为“否”，然后将一项与“是”的补充有关
You should be able to just allow data entry using a form based on a table (though for various reasons, I would use a form based on a query of the table) - just set the properties governing deletions and modifications to 'No' and the one pertaining to additions to 'Yes'