The database I need on the web right is currently in MS Access. We could move to SQL if that is a better solution. The DB keeps track of customers companies and addresses. There are two other sub-tables that are attached to this DB. One tracks multiple employees per company, and another table that tracks multiple equipment owned by company. We would like to have the database be accessed via the web put through a UserName and Password. This way each customer can maintain there own data. If a change is made by the customer I would like that "new" or "changed" data on hold until we can verify it, then place or release to the master database. We have a problem with customers getting machine serial numbers correct. Once the change or add has been made, a email or some notification is made to alert us to this. There maybe a better way to do this. The last part is customer location verification to distributor. Each of our distributors has a assigned area, this is done by County Codes. We would like to be able to idenfiy each customer to a distributor, both on the customer form, and via a form to the distributor. This way the distributor can access a form and see what customers are located in his area. The customer will be able to see on their information form what is the nearest distributor to them. I am sure there are other features which would be helpful and would open to any suggestions. This would be our first venture of this kind to the net with a database. Our idea of access to this new feature would be through our main website, with a logo/hotlink to jump to this customer only area. The next step on this project would be to expand the new secured area with additonal options and information for our customers. Our database is approx 5000 companies. We currently have SQL Server 97, our mainframe is a AS400). Our PC's run Windows 2000, and Office 2000 Professional. If you need additional information please let me know.
## 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 2000 or NT Internet Explorer 5 or greater