
Database Files:
===============

The database files are in Access 2003 format.

Users may convert them to any relational database.

The list of files used by HMS is
	AusDb: tables defines users and company
	GasDb: Accounting Tables.
	HmsDb: Hotel Tables.
	HsdDb: Hotel Statistical Tables.
	IcmDb: Items Cataloge Tables.
	MpsDb: Personnel Tables.
	MsmDb: Purchasing Tables.
	ScsDb: Stock Control Tables
Databases Used by HMA:
	AusDb: tables defines users and company
	exportDb: for transactions export/import
	HmaDb: Hotel Marhetting Tables.

The user must remove the read only attribute before using the files.

ODBC Data Source Names Should be defined for each Database file. The file odbc.reg includes registration entries for HMS files. The locations of files should be changed to the acual location in the user's server before running this program.

The files in this folder are initialized to be used for a new hotel. The user install the first application (assumed AUS) will be added to AusDb as adminstrator. He may use the application (AUS) to add other users including other adminstrators. The second application should be GAS  to define accounts used by other applications. The third application should be (ICM) to define the items used by outlets. The fourth application should be (HBD) to define the hotel basic data like room type, rooms, taxes, ... etc.

Updates:

April 23, 2007
==============
Database HmsDb.mdb
Table: [Guest]
Two fields Added: 
	[BirthPlace] Text(40), Allow Zero, Not Required
	[BirthDate]  Date/Time
After Guest Name Field.

Table: [City]
Change Field [cityCode] From Text To Number, Long Integer, Fixed, 0
This field will contain sequence numbers as city code.

Table: [RoomGuest]
Field [SourceCityCode] is changed from Text(12) To Number Long
Field [DestinationCityCode] is added after Field [SourceCityCode] with the same
	description as the new [SourceCityCode]. They are both pointed to records
	in table [City].

==========================
Helal Software House
http://www.helalsoftware.net
eahelal@helalsoftware.net
