Move MS ACCESS database & functionality to mySQL
$100-150 USD
Imekamilika
Imechapishwa almost 19 years ago
$100-150 USD
Kulipwa wakati wa kufikishwa
We currently have an Access 2003 "workflow" database with a form front end that users use to view data on the database. The form is kept on a local mdb file & it connects to a backend server mdb file. The database is extremely slow on the WAN. The database manages aspects of customer contact and to track what stage each job/project is at. This is a fairly simple requirement. Some key functions of the database at present: 1. Open a specific folder on the server 2. Attach documents 3. Track each stage and timestamp 4. Printing each workflow 5. Color coding to help see "at a glance" We propose to move all the data to a new mySQL database and provide the same functionality using the same "look and feel" front end GUI/form. The solution is up to the coder. All we need is for the data to be dynamic - ie if using php, the data being displayed MUST be accurate. Ideally, the solution would require the "push" to come from the database rather than a constant refresh which obviously increases traffic on the WAN/LAN if the data being requested is too frequent. We are open to suggestion for the final solution. Some enhancements will also be required to be incorporated into the new system. Coders will need to allow for future expansion of the system also. Some enhancements: 1. User management - at the moment the mdb file is easily accessed by all, with all data viewable. We need to have data selective according to the "group" the user belongs to. 2. Data is sorted by week in groups, then alphabetically. We need it to be sorted by week, but then by order of date/time the jobs were moved to this stage. Please bid only if you are able to give us a price on the project - blank bids or comments without figures will not be entertained. Some examples of previous work will obviously work in your favour if it displays a solution similar to our requirements. NOTE - you will see from our feedback that when we work with a coder once, we continue working with them in future.
## 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).
## Platform
serverside: LINUX PHP mySQL clientside WINDOWS XP PRO/HOME Any programming language used to access the db