restricting options

[Vicelikeplague]

Hello

I am not sure quite where this should be posted, apologies if I have got it
wrong!

I am trying to put together a database for our members to sign up for a
conference we are having. Included will be all the hotel details, the
problem I am having is that we have a limited number of each type of room. I
am not sure how to handle this in a database. How do I stop too many people
picking the same type of room. For instance if we have 10 double rooms
available, how do I stop the 11th person from trying to choose and book a
double room? Our intention is to have this on the internet as a "live"
system, without us having to constantly maintain it.

Is this even possible in Access?

Many thanks

 

[Arvin Meyer [MVP]]

Access is a desktop database application which can use a back-end database
(JET or any other ODBC compliant data engine) on a server. You will need an
ASP or ASP.NET application, or some other language to run over the Internet.
You cannot run an Access front-end over the Internet, and therefore will
need to put the logic in your Internet front-end.

 

[mscertified]

I would not use Access for a website. It has a number of problems too complex
to go into here. However, you can handle your issue in Access. You just have
your list of rooms in a table and as each one is booked you check it off.
after they all are checked, voila, no more left. Or you could have a table
called 'Rooms available' and you just deduct one from the count as each room
is booked. Of course if you are also handling multiple dates it then gets
more complex as you need a date-from and date-to for each room.
There are probably many off-the-shelf hotel reservation systems. Why
reinvent the wheel?

-Dorian

 

[Abrar]

Hello

I am not sure quite where this should be posted, apologies if I have got
it
wrong!

I am trying to put together a database for our members to sign up for a
conference we are having. Included will be all the hotel details, the
problem I am having is that we have a limited number of each type of room.
I
am not sure how to handle this in a database. How do I stop too many
people
picking the same type of room. For instance if we have 10 double rooms
available, how do I stop the 11th person from trying to choose and book a
double room? Our intention is to have this on the internet as a "live"
system, without us having to constantly maintain it.

Is this even possible in Access?

Many thanks