Creating random session ID in Access table

[Metroid]

The objective of this has changed. What I need to do is when a user wants to download a file they will click on the driver/file. Once clicked, they will be taken to a form page where they will enter their e-mail and name. Once they click the form page...this information will be entered into a database. [All in one action]. Once the information is entered into a database, they will be sent an e-mail with a link to the desired file.

I am a little stuck on how to do this. If anyone has a clue, any information will be much appreciated.

Thanks-in-advance

[PeOfEo]

Originally posted by Metroid
I know how to do this for with a simple +1 by having a session id table and incrementing it by one but I need something more secure. I need to generate a random string for a user to use to then access the particular document for download. What is the best possible way to do this? I know how to do this simply....but i need a more complex solutions.

Thanks-in-advance why do you need it to be random. Why not use an incrimenting feild? Or if you need something secure, why not encrypt it.