I need a routine to generate a unique number for a key

D

David

Due to reasons too complex to explain I need a routine to
generate a unique number for a key

I cannot use the autonumber Key feature for this since I MUST know the number before I add records. I must also be able to jump sequences in certain circumstances

I envision a table with one row 'next_number' which will
be accessed with exclusive lock and updated before lock is
released
Does anyone have reliable working code so I dont have to
reinvent the wheel
Also what happens if two users hit this routine at the
same time, do I need a short 'wait and retry' loop
I'm using ADO access in Access 2000. This is a multi-user
system.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need a routine to generate a unique number for a key 4
Need routine to generate unique number for key 3
Modify Sort Routine to inlcude All Data 2
Creating a Unique Key on Import 1
Auto Create a unique number from user data, for input into table. 1
Do I need a product key? 0
How to map a shortcut key to a routine in COM AddIn for Excel 2007 21
How Can Access Generate a Unique Random Positive Number? 2

Top