creaating a RANDOM and UNIQUE invoice number on insert!

[Don Pacino]

Hello,

I have created an access database where infomation is inserted using ASP and
automated functions inDW MX 2004.

Now... I need a way to provide the user with a unique sort of invoice number
thingy, but it must be always unique and reliable.

I just bought a few DVDs from amazon and receievedan invoice number something
like this 4701948q-487641-148714891for my order, I dont mind the length, as
long as it is Unique.

Does anyone know how i can acieve something similar?

[bthouin]

Why don't you just use Autonumber ? That's unique enough. Otherwise, you
can of course use a UUID (which is what Amazon is using), and there must
be plenty of code samples on the Net explaining how to generate one. But
it's very unwieldy, and, given that you're using Access, I guess you're
not going to have millions of invoice, right ? So just use Autonumber,
and forget about Amazon-like order numbers. They have millions of order
every day. Access wouldn't take that anyway...

Regards
Bernard

Don Pacino wrote:

> Hello,
>
> I have created an access database where infomation is inserted using ASP and
> automated functions inDW MX 2004.
>
> Now... I need a way to provide the user with a unique sort of invoice number
> thingy, but it must be always unique and reliable.
>
> I just bought a few DVDs from amazon and receievedan invoice number something
> like this 4701948q-487641-148714891for my order, I dont mind the length, as
> long as it is Unique.
>
> Does anyone know how i can acieve something similar?
>