Tom:

I have an application in which work order numbers are generated using the auto number feature. The system has been in use since the DOS days (10+ years) and I have not had a single problem; one of the installations had 10 users generating work orders at the same time. Please note that the approach that I use consists of inserting a new record with some basic information to generate the new number and then immediately retrieving the record in the EDIT mode.

Javier,

 

Javier Valencia, PE

President

Valencia Technology Group, L.L.C.

14315 S. Twilight Ln, Suite #14

Olathe, Kansas 66062-4578

Office (913)829-0888

Fax (913)649-2904

Cell (913)915-3137

================================================

Attention:

The information contained in this message and or attachments is intended

only for the person or entity to which it is addressed and may contain

confidential and/or privileged material.  Any review, retransmission,

dissemination or other use of, or taking of any action in reliance upon,

this information by persons or entities other than the intended recipient

is prohibited. If you received this in error, please contact the sender and

delete the material from all system and destroy all copies.

======================================================

 

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Tom Hart
Sent: Wednesday, June 08, 2005 11:49 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Networking

 

I will have a network with 2-3 users that will be entering data into the same table.  Each row will have a unique number assigned(using autonumbering).  If 2 or more are entering data at the same time is there a possibility of duplication of numbers.  I thought I saw a post recently that there could be a conflict.  Any thoughts or solutions on this subject would be helpful.

Tom Hart

 

 

 

Add FUN to your email - CLICK HERE!

Reply via email to