In Progress

Access Database Repair - repost


Small freelancer job in MS Access with MS SQL ’08 and VB Script.

We have an MS Access 2010 database (connected to an MSSQL ’08 server) that, upon click of a button, copies names & addresses and such from a set-aside processing table to its more permanent home [url removed, login to view] MySQL, we can partially avoid duplicate record creation brought on by this record copying using the REPLACE INTO syntax, but not in this version of [url removed, login to view] need a procedure that gets us to the same place, i.e., for any records which are already in the target table, UPDATE, otherwise INSERT, based on matching a given key. We're sick of inserting blind and scanning for duplicates afterwards!

We will not be able to provide direct access to the DB in question but can provide the record copying SQL statement and surrounding VB script on the button.

*Expected Output:*

·Any new VBScript and/or SQL commands that implement the requested action OR a completed example from your own Access creation

·If any new tables are required to complete the procedure, we will need the SQL definitions of said tables (of course).

Skills: PHP, Software Architecture, Software Testing

See more: vb creation, procedure freelancer, mssql freelancer, freelancer vbscript, freelancer statement, freelancer sql database, freelancer server software, freelancer permanent job, freelancer access job, db freelancer, access database software, database creation software, freelancer procedure, freelancer architecture job, sql duplicates, sql commands, freelancer vb, database question, mysql mssql script, mysql sql syntax, mssql procedure mysql, mysql repair database, script update mysql tables, access database php mysql, access sql insert example

About the Employer:
( 1 review ) Topeka, United States

Project ID: #4668326

Awarded to:


Hi, Please see pmb.

$22 USD / hour
(1 Review)

9 freelancers are bidding on average $22/hour for this job


Done Sir:) Dedicated and Professional committed to deadlines. Ready to start now.

$21 USD / hour
(44 Reviews)

Hi, we are a team of programmers and designers with expertise and experience in PHP, Mysql, jQuery and Ajax. We have coded and designed websites for various types of businesses very successfully. We have developed many More

$20 USD / hour
(52 Reviews)

Hi,i read your requirements and ready to do it. i already experienced with this staff. see my message for my experience and what i can offer for.

$22 USD / hour
(18 Reviews)

Kia ora! [url removed, login to view] are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$25 USD / hour
(5 Reviews)

Interested to work

$22 USD / hour
(1 Review)

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SE More

$22 USD / hour
(5 Reviews)

Dear Hiring Manager, I am working in IT sector for last 12 years starting from Junior Programmer-Senior Programmer-Tech Lead-System Analyst and [url removed, login to view] my technical skills and deliverable or technical sup More

$27 USD / hour
(0 Reviews)

Execução e planejamento dos testes. Documentação gerada com as funcionalidades do sistema Reportagem dos Bug´s e Re-teste dos bugs reportados.

$22 USD / hour
(0 Reviews)

I propose to do this. Please see private message

$16 USD / hour
(0 Reviews)