Generate Auto-number in Network Environment

[vbsavvy]

hi all

plz help me .... so confusing.....

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...!

System: VB 6.0
Dbase: MS Access 2000

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

[mayurvb]

Looks difficult. Why the receipt number is needed at the computer 1..4 etc
You can do the calculation at the time of inserting records anyways.
Event using Identity column can solve this problem

[Hack]

Looks difficult. Why the receipt number is needed at the computer 1..4 etc
You can do the calculation at the time of inserting records anyways.
Event using Identity column can solve this problem

I don't know if Acess supports IDENTITY, but, you can create an AutoNumber field which will auto increment on each INSERT and provide a unique number which can be used for your receipts.

[RobDog888]

Yes, Access does support Identity but its limited.