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. Idea for Internet-data-lookup see: [url removed, login to view] and see in attached file, the "krak [url removed, login to view]", sorry it's in local Data sites: [url removed, login to view] or [url removed, login to view] (Firma means company) 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) Idea for data-transport, see: [url removed, login to view] 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. The things you will make are marked, the rest is in local. Must be easy upgradeaple to SQL server2000 SQL queries and statements are prefered. Comments and suggestions are welcome.
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.
Windows (98), 2000 & XP, Access 2000 (SQL 2000)