I have a share database (multiuser). I split the database and I linked the
tables in each front desk database in each computer.
I have a form with an increment field. I used DCOUNT function of SerNo
(that
is an Autonumber field) and I add 1, On current event and it works if a
single user works in that form. If another one user used the form to add
data
then it gives the same increment value and when they try to save it they
get
an Error Message.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200802/1
