I have a job soon that will require me to move a Access backend to MySQL. Im working on all the conversion and a few other things. I would like to get the front end which is MS Access set up with link and re-link code as I work on development.
Im seeking the following things in the solution.
1. A form or easy method that will allow me to link and re-link linked tables from a development server to production server. (I have tables that will be linked to other data sources like a mdb file on the network, I do not want to relink. So it will have to be aware to ONLY update/relink MySQL connected sources.
2. DSN-Less connection that will handle either 32-bit or 64-bit clients.
all clients will be on MS access 2013 or newer.
My databases are large I would like to just have the solution as a separate project called.. [url removed, login to view] and I will import everything in the live solution later.
Ive found plenty of examples online for this so it doesn't sound like a huge project for someone with experience and may even have such a thing built already.
13 freelancers are bidding on average $214 for this job
Hello Sir, I am an MSAccess expert and would like to discuss this project with you. Thanks Aanvik Relevant Skills and Experience MSAccess Proposed Milestones $277 USD - Milestone