Useing userid or creating another!

[Crash1hd]

Looking for an opinion from anyone that would like to give it :) What was wondering is everytime you create a database file it ask for an autonumber file usually "userid" but for some reason or another I heard that its not very reliable where you could use a script that adds a number everytime to the database which would be more reliable the built in autonumber or adding a one to the next number on the next line both end up with the same result both database fields would show something like this 1 2 3 4 5 6 7 8 9 10 11 12 13 14.... in both

Just looking for opinions and thoughts cause I know that when you remove a line in the database field it actually skips that number and goes with the next one so if you remove line 3 and then add one it wouldnt put line 3 it would put line 4 but with the script version it would still say 3???? :)


Adam

P.s. I hope this makes sense :D

[Mhtml]

I have always been using autonumber and have had not one single problem. (That hasn't been my code ;))

People who try to tell you how horrible access connections are and that autonumbers are horrible are fools. (No offence to anyone from here who may say that ;))

Some people just over react and exaggerate.