Auto-number Dlm Network Environment

[vbsavvy 0]

hi all

plz help me guys ... stil confusing...like this:

i wanna generate a receipt number .... i got four computers that running at one time which refer to a server comp where the dbase is located... what im doing now is i read the highest number frm the dbase then i plus with 1.... but the prob is all those four computers wil have the same number n now i got redundant receipt number which is realy incorrect....

so i wanna ask frm u guys how to solve this matter so that if the current highest receipt no in the dbase in 100 so the 1st comp wil have 101, 2nd comp wil have 102, 3rd comp wil have 103 n 4th comp wil have 104 ... NOT 101...!

plz guys .... realy apreciate it..... thans a lot.....

System: VB 6.0

Dbase: MS Access 2000.