can 3 simultaneous users with Access database cause trouble?

C

COHENMARVIN

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
 
K

Kevin Spencer

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.
 

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

Members online

Forum statistics

Threads
473,774
Messages
2,569,598
Members
45,149
Latest member
Vinay Kumar Nevatia0
Top