OK, have my Kevlar on. I decided to create a solid unique ID number generator. The only restriction I used was to stay within the 10 character default field length. The value I came up with, I figure, has an odds of 1 in 2.59 billion chance of being reproduced (duplicated) in Windows & 1 in 259 million chance in NT.
Check it out:
int(seconds() *100000 + day(date()))
The resolution of seconds on an NT machine is 10 thousandths. In 95 an older, 1 thousandths. On a 133 Pentium I held down the CTRL+Y key and added records. Even in the NT setup no 2 records were ever near identical. It ain't perfect but it is getting close.
Tom