Find Jobs
Hire Freelancers

Microsoft Access VBA Project with MySQL Database Backend

$250-750 USD

Cancelled
Posted over 5 years ago

$250-750 USD

Paid on delivery
I already have a PHP web application, which uses a MySQL database backend. The current web application works very well. It is designed for multi-user internet-based access. I need to produce a Microsoft Access VBA project client, that can connect to a MySQL database _LOCALLY_ so that the end user can use the application when isolated without internet for long periods of time. Later, I will want to merge the new records from the local MySQL database with the primary MySQL database that is online. I can give you admin access to the web application, the hosted server, and the database. I just need to have it completely recreated using MS Access VBA project.
Project ID: 17432965

About the project

32 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Requirements: Recreate MySQL DB locally. Import lookup tables (as needed). Create ODBC connection to local MySQL DB Recreate web UI in MS Access enhanced with VBA Test / Approval Relevant Skills and Experience My 10+ yrs of MS Access, VBA, SQL Server, PHP, MySQL application devlp. exp. will produce a quality solution. Communication is a skill I'll rely on to understand your goals and keep you up to date. Proposed Milestones $495 USD - Delivery of fully approved application Hi, my name is Mark. With years of desktop database application expertise, I'm confident I'll create an application that fully meets your expectations. Since I'm new to Freelancers, I've submitted a low bid to be able to demonstrate my skills and build my reputation. Please review my profile, 5-Star reviews and thanks for considering me for your project.
$555 USD in 15 days
5.0 (15 reviews)
6.4
6.4
32 freelancers are bidding on average $528 USD for this job
User Avatar
Dear Employer. I am very interested in your task. I read your proposal carefully. I am skillful VBA and MySQL expert. Please contact with me. Best regards. Relevant Skills and Experience Database Programming, Microsoft Access, MySQL, PHP, Visual Basic Proposed Milestones $250 USD - Budget
$250 USD in 10 days
5.0 (213 reviews)
9.1
9.1
User Avatar
Hi! Consider this as blind bid. I am interested in that can I see a web application first? Relevant Skills and Experience MS Access MVP 2008 and 2009, MS Access professional developer for 25 years Proposed Milestones $555 USD - Completed project
$555 USD in 10 days
5.0 (338 reviews)
7.7
7.7
User Avatar
Hi there, Warm Greetings We came along with your request for Microsoft Access VBA Project with MySQL Database Backend and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Database Programming, Microsoft Access, MySQL, PHP, Visual Basic We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$450 USD in 7 days
4.9 (237 reviews)
7.8
7.8
User Avatar
We have successfully finished over 520 projects in last 18 years. ID : 17432965 Greetings, We are interested to work on this project, please find my comments inline with yours, 1)Microsoft Access VBA Project with MySQL Database Backend =>OK What version of MS Access you want to use ? Access 2013/2016 ? We can have MySQL as backend, what version of MySQL is it ? We can have MS Access ODBC DSN Less linked tables of MySQL. 2)I already have a PHP web application,.. =>OK, Are you going to have same MySQL for both the PHP and MS Access database ? The performance is little slow for Remote hosted Servers, this just to inform you. 3)The current web application works very well. It is designed for multi-user internet-based access. =>Ok 4)I need to produce a Microsoft Access VBA project client, that can connect .. =>Ok, Please confirm that MySQL is on the same server where you are going to run Microsoft Access. In such case you will get a good performance. Even if the MySQL is in Local Area Network(LAN), you can expect good performance. But for hosted internet server it slows down. 5)Later, I will want to merge the new records from the local MySQL .. =>I am little confused, the local MySQL database, will it be different from the one connected to PHP website ? the data synchronization, I need to review each table for unique fields or we may have to use GUID , because both the databases can have similar new IDs but they would be different data.....I can explain on this through voice
$833 USD in 15 days
4.9 (370 reviews)
7.8
7.8
User Avatar
Hi there,I am Miljan,VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! Relevant Skills and Experience Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Proposed Milestones $388 USD - / Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$388 USD in 3 days
5.0 (53 reviews)
7.0
7.0
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Could you send me your files ? Regards, Fabrice
$277 USD in 10 days
4.8 (95 reviews)
7.4
7.4
User Avatar
Hello, I'm Abu Gosia. I'm interesting your project very well Can you please show me current application. I m quite well experienced in these jobs. Let's go ahead with me. Thanks Relevant Skills and Experience I'm good in Microsoft Access, Visual Basic, C#, .Net, MVC, Angular.js, ASP.NET, PHP, Laravel, Codeigneter, Wordpress, Open Cart. Proposed Milestones $666 USD - initial
$666 USD in 15 days
4.8 (167 reviews)
6.8
6.8
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Relevant Skills and Experience I will do it in Excel VBA. Proposed Milestones $600 USD - Project requirements.
$600 USD in 10 days
5.0 (106 reviews)
6.3
6.3
User Avatar
I can code Ms Access front end with MySQL back end from scratch using vba, SQL/ADO, ODBC coding Relevant Skills and Experience ms Access,vba,dao,sql, ado, Excel, Excel Object Model Proposed Milestones $750 USD - default
$750 USD in 10 days
4.6 (59 reviews)
6.2
6.2
User Avatar
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have Microsoft certifications in .Net development and sql server. I also have a lot of experience in desktop and web development. Regards
$555 USD in 10 days
4.9 (44 reviews)
5.4
5.4
User Avatar
I have done similar task like you mentioned for a couple of my clients. I can help you with my vast skills on MS Access, advanced VBA and SQL Server. Relevant Skills and Experience I have been working on this technology since 2007. Let's discuss over chat. Thanks Proposed Milestones $350 USD - Offline Tool $150 USD - Sync to the cloud database
$500 USD in 4 days
5.0 (22 reviews)
4.9
4.9
User Avatar
Hello, I am Tania, I am a certified Graphic designer From past 4+years now. I am proficient in the Adobe Illustrator, Adobe Photoshop and In Design for 3D graphics Relevant Skills and Experience - Web Designing and development Logo & Icon Design Newsletters Corporate Catalogs Brochure Design illustration Flyer Design T-shi& Cgn & Book Covers Banner Design Presentations Advertisements Proposed Milestones $555 USD - 1
$555 USD in 10 days
5.0 (40 reviews)
5.1
5.1
User Avatar
Hello, sir i can write access VBA code to connect to your local mysql database , can merge both data in local , online mysql databases using VBA it seems very interesting job waiting your answer Regards
$250 USD in 3 days
4.9 (73 reviews)
5.1
5.1
User Avatar
Hi, Could you send me more details about the website database in order to design a similar one in Access the work Relevant Skills and Experience Hi, I am a professional Access developer I have done many great projects in Access have a look at my profile and I can finish your project. Proposed Milestones $250 USD - Access DB
$250 USD in 10 days
5.0 (8 reviews)
3.7
3.7
User Avatar
Dear Sir: I can develop the application for you. But I have another idea that I would like to share with you. You can even do one thing, you can install your remote web application to your local pc and will be able to use it offline and synchronize database with the remote database whenever you want to. Such as update data from remote MySql database to local MySql database or upload local MySql data to remote MySql Database. If you go for this process then within a short time you can start working with your application as you don't have to waste time in developing the new application. On the other hand, you can go for your idea of using MS Access database and I can make it happen too. Please feel free to contact me for further queries. Best Regards, Tanvir Rumman
$666 USD in 10 days
5.0 (6 reviews)
3.7
3.7
User Avatar
Dear Sir, Over all 15 years of IT industry experience. Development of Web Application and Windows based Application using Microsoft Technologies. My experience on MS Access and VBA will definitely resolve your issues. My expertise on following tools are hereunder: - VBA and Macros using Excel and Access - VB.Net, VB6.0 - Report designs with Crystal Reports, data report and excel - Back end SQL Server or MS Access EDUCATION: MCA (Master in Computer Application). Looking forward to work with you. Thanks and Regards
$277 USD in 10 days
4.8 (13 reviews)
3.6
3.6
User Avatar
I've understood your concept clearly. All is good. Relevant Skills and Experience I've 10 years experience with PHP, Mysql,MS Access , Laravel, Codeigniter, Javascript. I have also rich experiences in creating the schema of the database. And I am very interested in VBA project. Proposed Milestones $800 USD - milestone I can work now on and I will finish your project asap. If you are looking for best candidate, you are in the right place now. Hope you will enjoy working with me. Regards! Legendary C.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this for you as I have build a quite a few similar access projects in corporate environments for LOB apps. Relevant Skills and Experience 15 years experience in VB.Net and VBA Proposed Milestones $600 USD - Job completion
$600 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Would you consider SQL compact server (embedded) with WPF as the solution
$1,111 USD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a software company that has more than 200 customers based mainly on MSACCESS projects with Mysql backend
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Scottsdale, United States
5.0
12
Payment method verified
Member since Feb 2, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.