Room booking system

davea300

Registered User.
Local time
Today, 23:59
Joined
Mar 16, 2007
Messages
164
Is there still a hotel/room booking system sample database available on the forum?

I remember seeing one a while back in the samples forum but can't find the thread now.

If it's not here anymore does anyone know of any samples I can look at?
 
I unzipped the roomres2000.zip
And I try to run the roomres2000.mdb in Access 2007.
But I got an error: connection to utility.mda is broken, or something like that.

This could be a very usefull piece of software for me.
Does anyone has a solution or knows code for MS Access who does the same ?
 
Hi Uncle Gizmo

Using the given database, I have done some booking (dummy) and have identified a number of problems that occur in the database.
1. example room 102 have been booked by administrator on July 15 until July 22, i try to book into the same room (102) on July 16 until July 18. (date between) previous booking. Booking are allowed .. no error message.
2.Duplicate message only occurs when a new booking date exactly same with start & end date on previous booking
So..can u give me the best solution if i dont want to make a double boooking on the same room.

Tq
 

Users who are viewing this thread

Back
Top Bottom