Access Database Repair

Avg Bid (USD)
$28 / hr
Project Budget (USD)
$15 - $25 / hr

Project Description:

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 table.In 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 MSSQL.We 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).

Hours of work: Unspecified Project Duration: < 1 week Skills required:
PHP, Software Architecture, Software Testing
Hire fjs1975
Project posted by:
fjs1975 United States
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$15 / hr
Hours: 40 hr/ week
Hire rajeshsonisl
$50 / hr
Hours: 25 hr/ week
$16 / hr
Hours: 20 hr/ week
$25 / hr
Hours: 20 hr/ week
$15 / hr
Hours: 30 hr/ week
Hire FreelancerLLC
$25 / hr
Hours: 25 hr/ week
Hire ChrisAU76
$25 / hr
Hours: 10 hr/ week
Hire post3122
$50 / hr
Hours: 16 hr/ week