>Any quick fixes

Why not lock the table from updates from other users while one user is getting a number. Put a retry loop with a delay (use INKEY) in to handle the time when a user tries to get the next number but it is locked by another user.