Hello all, this is my first submission to your great community and I hope to be a regular member from now on.
My question regards the updating process from a local MS Access database to a remote MySQL database. To be more specific, i have a local MS Access DB and I need to frequently update the online db (mysql) to keep the stock level up-to-date on my website.
So far, the only thing I've found is the solution of linked tables but I'm sure which way to go from here. How exactly will my local db update the remote db?
What happens during the updating process as far as accessibility? Will the visitors have access to the website or will MySQL lock the database for exclusive use?