We are an benefits administration company, which is looking for a long term relationship with an Access/VB/MS SQL developer/expert. Expert, being the keyword.
We have an Access Database that has grown with the company. It is over 150 tables, 500 queries, 150 forms, and 200+ reports. The application has served us well, and continues to serve us well. The database has grown to 200MB and the number of users and records are starting to impact performance.
Migrate to MS SQL, maintain the same functionality we currently have. Forms, Reports, and Queries need to continue to work.
Couple of enhancements to the current application.
Implement SQL reporting services or similar program to offload reporting and automate the process..
Correct the code so that some of the data entry problems we currently experience are filtered and corrected before they get into the database.
Simple queries to help normalize the data.
Minor fixes and some automation.
Write a new application on MS SQL. New application will have better integration with 3rd party systems (xml), and provide web access to our clients to view benefit and insurance claim information (.net).
That gives you an idea of the long term relationship we are looking for. We are looking for responses on PHASE 1 ONLY AT THIS POINT.
Please provide references, experience, and examples of work if possible. Preference will be given to those that can communicate how they have supported clients on a long term relationship and someone that could communicate how they would work with us in a long term relationship.