Hi, hwo do you actually lock the database from the concurrency issue? thanks





Looking at this 2 sentences



1.-    SQLUpdate = "UPDATE Show " &_

              " SET Show.free_seats=" & free_seats & " " &_

              " WHERE Show_ID=" & show_id





2.-   SQLinsert = "INSERT INTO Booking ( show_id, booked_seats ) " & _

            "VALUES ('" & show_id & "', '" & tickets & "')"



it seems that sometimes your show_id is an integer and other times is an

string.

Not very consistent. It seems that perhaps free_seats and show_id fields are

text fields. Would it be the case you must UPDATE using ' '  in your SQL.



I recommend u two things:



You should use one recordset with a sql sentence with two joins instead of

opening three recordset. It's much faster.

You should be careful with the update. If you have many people accessing

your database at the same time you are going to have problems. You must lock

your database from the start of the page until the update if you don't want

to sell more seats that the ones you actually have.



Regards,

Gonzalo