Database Setup Best Practise
What is the best practise for setting up the hotel software database?
By default when the software is installed, the program looks for a database local to where the software was installed, i.e it looks in the db folder and a database called data.mdb. You can leave this alone and the software will work correctly, but there may be occasions when you need a bit more flexibility. Below are examples describing the best practise for database setup.
Single User
If there is only going to be one user using the hotel software then we recommend putting the database into a root folder on your
hard drive. For example: c:\hoteldata
The next step is to let the hotel software know where the database is. You can use
the networking tool provided with the hotel software to set
the database path.
Mulitple Users
If multiple users will be accessing the same database then the database needs to be in a common location such as a shared drive. Once a location has been decided on then the database should be copied there. Finally, use the networking tool to set the database path from each computer that uses the hotel software.