We have been developing multi user applications using VB as front end and MS-Access as back End.
In each of the transaction modules(s), the system generates a serial number for a transaction (by referring to a control table and adding 1 to the last transaction number of the transaction type).But when these transactions are executed by more then one users simultaneously at the same instant of time, the same number is generated by the system instead it should have generated a different transaction number for each of the user (or terminal).
how to achieve this using VB/ACCESS ?
