The goal is to build an online service log system described and defined by these screens. Please do not make any assumptions as to the desired functionality of the screens/pages within this document. It is very important that the program follow the enclosed design. If a required piece of information can not be located or is unclear, feel free to contact me at my email address. Please see attachment for program design. The bulk of the program must be written using ASP (not .NET) standards and making use of VBScript for data processing and page creation, with JScript used to handle page events like populating dropdowns based upon data from another field. You may use a VB ActiveX DLL to handle page processing in the background. The program will be served on a Windows 2000 SP3 machine using IIS, and must be viewable using ActiveX and frames compatible web browsers. A Scheduled Reminder Program must be written in VB 6 and must run as a scheduled task. Every night at a specified time, the program is shelled from a Windows 2000 scheduled task. The Program looks at the schedule, and emails any necessary reminders. Then, it will unload itself after emailing the necessary reminders and updating them as mailed. The Database backend is an already constructed Microsoft Access 2000 database. Attached is the layout of the tables from that database. The layout may be changed as needed to meet programming needs with prior approval. The database will be provided upon bid acceptance.
1) Complete and fully-functional working web based program(s) in ASP form as well as complete source code of all work done along with any components required for functionality. 2) Complete and fully-functional working reminder program in executable form as well as complete source code of all work done. 3) Complete ownership and distribution copyrights to all work purchased.
Web based portion must run on Windows 2000 SP3 IIS and access the Microsoft Access 2000 database using ADO 2.6 with no additional non enclosed components required. It must be viewable in a standard ActiveX and Frames compatible browser with a minimum resolution of 800x600. The Reminder program must run on Windows 2000 and work against the Microsoft Access 2000 database.
## Deadline information
Program must be in a test/beta state by 2/5/2003. The Coder may receive partial payment based upon partial code completion through a special agreement. The Entire program must be completed no later than 2/14/2003.