Small Windows App to Access MySQL DB: Queue Monitor for PerlBill

We're looking for a small application that allows end users to submit and track the status of tickets that they submit to our online CRM (Perlbill more info available at [login to view URL]). We're looking for a program written in VB with an Access Backend that: 1) Allows a user to submit a trouble ticket from their desktop. This can be accomplished by either allowing the program to send email to the script (in a way that is not SMTP dependent) or by gaining access to the MySQL database and tables using user/pass from the desktop applet. 2) Allows a user to track a trouble ticket from their desktop. Each time a user submits a ticket, a record in a local DB should be created so that the user has a running list of his/her tickets and support responses to that ticket. 3) Alerts a user to responses to their trouble tickets by way of a MSN Style popup and animated icon in the system tray. The program should check in congifurable intervals (e.g. every 30sec, every min, every 2 minutes) for responses to their trouble tickets. These responses should be grouped with the original ticket. When a response is received for a given ticket a MSN Style Popup should be the first notification and then a blinking system tray icon notification. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). 3) If the web based portion of the program needs to be modified the coder is responsible for backing up any changed files and adding comments where changes have been made. The coder also agrees to make changes in a test enviroment first (provided by the seller) and then in the production environment after changes have been tested and approved. 4) The coder is responsible for providing complete source, scripts and installers. ## Platform Win98, Win98se, WinME, NT 4.0, 2000 Pro/Server, XP and Windows 2003 Server