A) Record all phone calls to a Access2000 database. Our serial device delivers diffrent data formats, most used is A12345678#R, starting with A ending with R Write a log in tabel, If data do not exist in tabels mark it for later lookup via internet (sampel is provided) B) Update tabels with data found on internet. C) Data should be stored on the local Access workstation and once a day transffered via internet to the central server (The datadase on the server has the same tabels) ( Any ideas on how to do that, simpel ?) The central database should be abel to record call data from several workstations, these workstations are equiped with hardware and seperat phone number, hardware on com1 and com2 at the same time and same workstaion must be a possibility. MDIform is supplied for the forms to run in, other projects are intendet. There must be at setup form for setting up data tranfer to server time. Must be easy upgradeaple to SQL server2000 SQL queries and statements are prefered. Comments and suggestions are welcome.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows (98), 2000 & XP, Access 2000 (SQL 2000)