This job is about testing and upgrading the database and answer some specific questions related to mySQL? and ms access? & VBA databases and internet related questions. Ms access FE? files will need to be placed on more computers and they will access to mySQL BE which will be placed on the server via mySQL odbc connection or another connection.
The job will consist of the following parts (basically if the question 2 is answered YES, otherwise I am afraid I can close the bid) :
1) Upload my mySQL database (BE) example file which contains about 30 tables on mySQL server. Then the odbc connection should be set to link tables between ms access FE (placed on my, your and another comp as well) and mySQL BE (placed on server you choose & provide). The mySQL server should allow odbc (or if possible other) connection from any IP address and at least 50 connections at the same time. BE database to be stored in the server approximately for? 6 months. You must provide the server and place BE. I will do FE files.
2) The first problem I realized is the connection speed. Ms access FE download all data from table(s), e.g. when there is a continuous form or some form based on query which needs all data from table(s). I need to move the calculations and other processes from the local computer to? the server side. Only resulting data should be send to the FE. Is it possible ? If yes, I need an explanation how to do it. Probably queries and VBA code should run on the BE server side. - About 5 examples to be solved in order to prove the workability (browse form - see next task, specific calculation in VBA using queries, etc.)
3)? The task is related to the previous one. One of the continuous form will need to be updated. The form is based on the table? / query. There are about few thousands rows in the table(s). The form displays all data from the table / query. User can go through all data just by scrolling, can update them, etc. It takes ms access plenty of time to download all data from mysql BE. Therefore the database should be updated the way it will be “workable?? (means fast enough to browse through it). VBA code and queries calculation to be moved to the server side.
prefering Skype communication & payment after each step is completed
Later? I am going to? test the workability of ms access FE for the period of approximately? 6 months. If there is an issue which I cannot handle myself easily I am going to make a bid here asking for solution.