generating unique identifiers

  • Thread starter Thread starter Ibrahim Shameeque
  • Start date Start date
I

Ibrahim Shameeque

Hello
Is there any alogrithm that I can use to convert a variable length string
into an unique id?. The id will consist of 4 chars and two numbers. Everytime
I use the alogrithm on the same string, it should create the same unique
identifier. Any help is greatly appreciated.
--
 
Post the code you are using to create the id and some examples of strings you
are using.
 
Hi
If there is a description column in access table and the value is for
example "This is my table", this string is unique to the table. Now I want to
create a 6 char unique id for this string. Every time i use this string, the
same unique id should be created. Although this string is unique, i do not
want to use this as a unique identifier because this string is variable
length and it may go to 30 characters. Thanks in advance for your help
 
Hi
If there is a description column in access table and the value is for
example "This is my table", this string is unique to the table. Now I want to
create a 6 char unique id for this string. Every time i use this string, the
same unique id should be created. Although this string is unique, i do not
want to use this as a unique identifier because this string is variable
length and it may go to 30 characters. Thanks in advance for your help
Click to expand...

Do a Google search for "hash code algorithm". There are several, but none are
built in to Access. These can be pretty good at coming up with unique values,
but they cannot be perfect: there are only a finite number of combinations of
six characters, and there are more possible 30-character strings than that by
an enormous margin.

John W. Vinson [MVP]
 
Back
Top