Access Query Modification

$30-250 USD

Completed

Posted

almost 10 years ago

$30-250 USD

Paid on delivery

Hello I have a very small project, I need to get an MS Access Query to update one field in a MySql database. I downloaded the tables via ODBC and put the query together, but when I link the Access tables with the MySQL table I cannot write to either Access or MySql tables. I’ve attached the database. The query name is Inventory Update – Store and it can be found in the Unassigned Objects section, I need to update the very last field (qty) which is a MySql table field by entering the number found in the field just to the left called (New Quantity) I will also need to place a check in the Store Updated field. I will need the freelancer to let me know what they did to correct the query so I can avoid this problem in the future. My maximum budget is $40 USD Thank you for your interest!

Microsoft Access

Project ID: 5977990

About the project

4 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

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:

@danielrinf

Hello, I already solved your problem on that query, for that reason I have offered little that is actually a very simple solution. Let me know by private message any doubts

$30 USD in 1 day

5.0

(1 review)

1.0

4 freelancers are bidding on average $167 USD for this job

@abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with SQL Server and access databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Access and VBA to develop all types of requirements related (Forms ,Queries ,Reports ,Database conception and enhancements) ,and given my experience, i am persuaded to give you High quality of work delivery withing budget and time Best regards,

$263 USD in 3 days

4.9

(7 reviews)

4.7

@rlpenn

I can take care of the for you. Could you please send me a copy of the mysql table as an Access table? I can't open the mysql link. I would be happy to teach you how to write an update qry.

$40 USD in 1 day