问题描述
我正在尝试为Inventory控件和多个用户设置Access数据库。我的想法是输入并保留库存运动的记录：增加，减少，贷款，转换（销售库存到演示）等。然后，库存
的当前状态将通过累加所有运动来获得对于每个项目，加上我会保留一段时间内发生的事情的历史记录。
我想知道，如果它与多个用户兼容。例如，要销售商品，我会有一个临时表，其中包含所有小工具A（带有序列号），然后用户会选择正确的序列号，然后该商品将售出
。但如果两个人同时出售物品，他们会互相干扰吗？例如，"items_temp"表示"items_temp"。 table必须在开头清除，所以如果用户1清除它然后开始用项填充它，然后
然后user2开始销售并清除临时表，它将删除user1所做的一切。你怎么在访问中避免这种情况？
I am trying to set up an Access database for Inventory control and for multiple users. My idea was to enter and keep a record of inventory movments: additions, subtractions, loans, conversions (sale inventory to demo), etc. The current status of the inventory would then, for example available by adding up all movements for each item, plus I would retain a history of what happened over time.
I am wondering, though, if that is compatible with multiple users. For example, to sell an item, I would have a temporary table with all items of gadget A (with serial numbers), and a user would then pick the right serial number and then that item would be sold. But if two people were selling items at the same time, would they interfere with each other? For example, the "items_temp" table would have to be cleared at the beginning, so if user 1 clears it then starts populating it with items, and then user2 starts selling and clears the temp table, it would delete everything that user1 had done. How do you avoid that in access?
这篇关于多用户库存数据库的MS访问权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！