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.
Bid covers creating a DSN-less connection in MS Access that may be modified by the user through a MS Access form. Relevant Skills and Experience 22 years MS Access/VBA experience. Proposed Milestones $3 USD - Refine Daha Fazla
13 freelancers are bidding on average $214 for this job
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this MS Access DSN-Less Connection task as per your requirement Relevant Skills and Experi Daha Fazla
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
Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. Email sending with MS Ac Daha Fazla
Access and MySQL exposure will help us to provide solution for same
Veteran database developer. Have done several such in-process migration projects Working on 1 such project on freelancer now Relevant Skills and Experience 15+ years Access 7+ years MySQL Plenty of migration experienc Daha Fazla
I can built for you a project to link a set of MySQL or Access tables to any .accdb file. It would be ideal build a table that specifies the tables you want to link mediante un campo lógico (y/n). Relevant Skills and Daha Fazla
I have lot exp on MS-access using as database in windows applications. Relevant Skills and Experience I have more than 13 yrs exp as Architect, Tech Lead, Developer in C#, ASP.net, VB.Net, XML, SQL server, MS-Access, Daha Fazla