workability / testing of ms access FE - mySQL BE

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

## Deliverables

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.

Evner: Ingeniørarbejde, Microsoft Access, MySQL, PHP, Projekt Ledelse, Software Arkitektur, Software Testning, Visual Basic for Apps

Se mere: test prove it questions, testing user, testing skype connection, scrolling table, prove it test examples, prove it example test, php and mysql connection, parts database access, ms project test, ms access parts database, job ms access, how to code computers, examples of databases, examples databases, data set testing, databases examples, answer my query, access parts database, job testing, ms access job

Om arbejdsgiveren:
( 1 bedømmelse ) United Kingdom

Projekt ID: #3311599

2 freelancere byder i gennemsnit $51 på dette job


See private message.

$51 USD in 60 dage
(31 bedømmelser)

See private message.

$51 USD in 60 dage
(1 bedømmelse)