Microsoft Access 2003中的数据重叠 [英] Data overlapping in Microsoft Access 2003

问题描述

嗨朋友们，

我的名字是Niranjan，我在VB 6.0和Access数据库中有一个小项目...



我在LAN中连接了3个系统，项目在所有这3个系统中运行。

发生的事情是当所有三个用户一次保存记录时，数据库中的记录与相同的账单号码..



请帮助我解决这个问题。





谢谢。，

Hi friends,
My name is Niranjan, i have a small project in VB 6.0 AND Access Database...

I have 3 systems connected in LAN, and the project is running in all these 3 systems.
whats happening is when all three users are saving the record at a time, the records in the database are overlapping with the same bill number..

Please help to get me out of this problem.


Thank You.,

推荐答案

你有几个选择...这里只是几个



向RyanDev致敬 - 尝试实施一些并发规则......看看这个讨论关于mdb并发性 [ ^ ]



向AlexDpars点头......你可以有一个自动递增的列，并将其用于您的发票号...此链接已旧但仍适用自动生成的字段 [ ^ ]。您可能需要在尝试后重置该数字... 如何重置自动编号字段 [ ^ ]。请注意，许多人不喜欢Autonumber字段 - 但是，我已成功且经常使用它们。



您可以升级到更强大的多用户数据库 - 那里有几种产品，但您可能仍需要考虑构建并发规则 - 许多其他RDBMS将带来的优势是能够使用触发器/存储过程来实现这些规则。

You have several options ... here are just a few

With a nod to RyanDev - try implementing some concurrency rules ... have a look at this discussion on mdb concurrency[^]

With a nod to AlexDpars ... you could have a column that auto-increments and use that for your invoice number ... this link is old but still applies fields that generate automatically[^]. You might want to reset the number after trying it out ... how to reset an Autonumber field[^]. Be aware that many people do not like Autonumber fields - however, I've used them successfully and frequently.

You could upgrade to a more robust multi-user database - there are several offerings out there but you will probably still have to consider building in concurrency rules - the advantage that many other RDBMS will bring is being able to use Triggers/Stored Procedures to implement those rules.

这篇关于Microsoft Access 2003中的数据重叠的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！