can 3 simultaneous users with Access database cause trouble?

Discussion in 'ASP .Net' started by COHENMARVIN, Sep 26, 2005.

  1. COHENMARVIN

    COHENMARVIN Guest

    We are thinking of creating an application that allocates seats on a
    plane to users. Each user might ask for a few seats, and its possible
    that we would have 3 different users simultaneously trying to reserve
    seats. Can this cause trouble?
    Suppose 2 users see that 4 seats are left. They simultaneously try and
    reserve 4 seats. Is there a way to prevent one of the users from
    reserving the seats? If not, we would be left with negative 4 seats.
    Or suppose two users try and update the same record at the same time?
    One of the updates would be lost.
    Finally, does asp.net with Microsoft Access support transactions?
    Thanks in advance,
    Marvin
    COHENMARVIN, Sep 26, 2005
    #1
    1. Advertising

  2. You should really think about using SQL Server instead.

    --
    HTH,

    Kevin Spencer
    Microsoft MVP
    ..Net Developer
    I'd rather be a hammer than a nail.

    "COHENMARVIN" <> wrote in message
    news:...
    > We are thinking of creating an application that allocates seats on a
    > plane to users. Each user might ask for a few seats, and its possible
    > that we would have 3 different users simultaneously trying to reserve
    > seats. Can this cause trouble?
    > Suppose 2 users see that 4 seats are left. They simultaneously try and
    > reserve 4 seats. Is there a way to prevent one of the users from
    > reserving the seats? If not, we would be left with negative 4 seats.
    > Or suppose two users try and update the same record at the same time?
    > One of the updates would be lost.
    > Finally, does asp.net with Microsoft Access support transactions?
    > Thanks in advance,
    > Marvin
    >
    Kevin Spencer, Sep 26, 2005
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mark
    Replies:
    1
    Views:
    349
    Gerben van Loon
    Jan 20, 2004
  2. Dan V.
    Replies:
    12
    Views:
    1,205
    Dan V.
    Jul 13, 2005
  3. accyboy1981
    Replies:
    1
    Views:
    624
    Vadivel Kumar
    Jul 20, 2006
  4. PerlFAQ Server
    Replies:
    4
    Views:
    129
    brian d foy
    Jan 3, 2011
  5. PerlFAQ Server
    Replies:
    0
    Views:
    148
    PerlFAQ Server
    Mar 30, 2011
Loading...

Share This Page