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.. [login to view URL] 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
Bu iş için 12 freelancer ortalamada $213 teklif veriyor
Access and MySQL exposure will help us to provide solution for same
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
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
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
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
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