Find Jobs
Hire Freelancers

Sync MS Access Table with MySQL Table in a existing Form

€8-30 EUR

Completed
Posted about 8 years ago

€8-30 EUR

Paid on delivery
Project based on a MS Access Form in which the user can add/edit Events and plan rooms. All entrys are in one MS Access Table. The MySQL table is totaly the same as the Access excepting the Date field. If the user change or add an event every changes should assumed in the MySQL table(which is connected via odbc). Other way to solve the Problem is to use only the MySQL as the only keytable and exclude the Access Table. The problem is here that the functions in the form expect an integer for the Date and in the MySQL it's a date.
Project ID: 10389769

About the project

9 proposals
Remote project
Active 8 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
Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you would like to Sync Access Table with MySQL Table in an existing Form or you would like to link the MySQL Table directly to the form so that user can enter data directly in MySQL table. I have 6 year's experience designing and developing Microsoft Access Application with advance knowledge of SQL and VBA. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio. Thanks.
€26 EUR in 1 day
5.0 (52 reviews)
5.4
5.4
9 freelancers are bidding on average €18 EUR for this job
User Avatar
you can use the date from the id table .
€30 EUR in 1 day
4.9 (12 reviews)
4.9
4.9
User Avatar
Hello Sir, I have gone through your requirements regarding Sync MS Access Table with MySQL Table in a existing Form. we brief and understand your idea and preference for job as you are looking for. I have more than 6+ years of experience in .NET, c#.net, vb.net, asp.net, MVC, sql, mysql, Oracle, Azure, Entity Framework, Linq, Umbraco, Telerik, JQuery, CSS, HTML, Kendo UI, RDLC Report, Crystal Report, BioMetric Integration. I have developed more than 10 projects. Please send me message for further conversation. Thanks, Arity Infoway
€29 EUR in 1 day
5.0 (7 reviews)
3.8
3.8
User Avatar
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
€12 EUR in 1 day
4.9 (6 reviews)
2.8
2.8
User Avatar
hi i am ashish i have read your requirements and ready to work with you on this task if you are ready to work with me then lets have a chat to discuss further thanks
€19 EUR in 1 day
5.0 (3 reviews)
2.0
2.0
User Avatar
Dear Sir or Madam, I am writing to express my interest in this project. My name is Bakhtiyor, I am a web developer from Tajikistan with more than 10 years of experience in this field. My mother tongue is Tajik and I am fluent in English, Spanish and Russian languages. During my working career I had a chance to work in several foreign companies too. They were Software company Orangeweb in Russia as a software developer, Center of singular investigation on information technologies at University of Santiago de Compostela as a researcher and Transparent Language Inc. in USA - leading provider of language learning software as a software developer. During my working career I worked with following programming languages and used technologies like: php, python, java, R, codeigniter, laravel, zope, oracle, mysql, apache, html5, css3, sass, less, javascript, angularjs, jquery, twitter bootstrap, gulp, bower, etc. I am well organized, highly motivated, communicative and very punctual person. I feel I am suitable for this project as I have a great deal of experience in this field because I worked and gained experience as a software developer and know several foreign languages. Thank you for taking time to consider my application. I am available for contact and/or interview at any time. Should you require further information, do not hesitate to contact me. Looking forward to hearing from you. Bakhtiyor
€24 EUR in 0 day
5.0 (1 review)
1.4
1.4
User Avatar
I m experience computer programmer in VB.net/vb/access Please consider me, I can solve it real fast.
€8 EUR in 1 day
5.0 (1 review)
0.7
0.7
User Avatar
A proposal has not yet been provided
€19 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings! 1) The kind of date format used in MS Access one specifies in the table designer, there are many of them. Moreover, one can specify even own format for the dates (to be correct, one chooses not a format, but rather kind of the representation of the format). Then , input field of the form that accepts the date you enter have to respond to the chosen format. 2) If some function in the form (?) need an "integer" representation of the data, no problem, there are cint(date value) and cdate(integer value) functions to use whatever you need. 3) Finally, if to leave everything as it is, you are flexible to perform cdate(your integer date) while saving date to MySQL. Just to doublecheck: one has to be careful with date representation concerning locale settings - 01 May of 2016 might be represented like 01/05/2016 or 05/01/2016 depending on it. I mean that Access and SQL may have (this is to check) different locales. So, I can either assist you via TeamViewr session or make needed changes if you send me the file. Or just make it yourself after these instructions :) Please feel free to contact me. Regards, Sergey
€14 EUR in 1 day
0.0 (1 review)
0.0
0.0

About the client

Flag of GERMANY
Neuhof, Germany
5.0
17
Payment method verified
Member since May 6, 2015

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.