Updating data base

Hi,
Most of the things you mentioned are automatically taken care of by the database
engine. All that you need to do is to trap the error messages, and show to
the user some decent message (e.g. someone tries to modify a record while
another tries to delete it. You need to lock the shared data resources before
doing any updating/deleting etc.)

Have fun!
Ajith

"gupta" <guptaparul@hotmail.com> wrote:
>
>Hi,
>I am writing a system that takes inputs from user in a form and then add
>that data as a new record in database. Now there could be a situation where
>a numbers of users submit their form simultaneously, in that case is there
>any kind of queue system maintained by the database which keeps a track
of
>all new records to be added and then adds thm one by one, or will there
be
>a possobility that some users will get an error that database cannot be
updated.
>I am using ACCESS and\or MS SQL Server 6.5\7.0. Do I need to handle such
>situation in my code, if yes how?
>
>I have a dedline to meet and need the answer ASAP.
>