Access two tables synchronization, How!

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

General discussion

Creator

Topic
May 11, 2003 at 9:43 am #2306546

Access two tables synchronization, How!

Locked

by techrerpublic · about 19 years ago

Ok… first I’m not an DB expert like all of you, just a common break fix guy!

Facts:
a) inventory db has over 10500 records
b) inventory from various manufactures are changing nightly.
c) flat delimited text files that I have to download nighltly.

Problem:
1) how can I synchronization my inventory db on my main inventory db on a nightly schedule, to reflect only the new changes from the other manufactures flat files that I have local?

Any succestions would be greatfull…

thks… Gary

This conversation is currently closed to new comments.
Creator

Topic

All Comments

Author

Replies
- May 11, 2003 at 10:58 pm #3358293
  
  Access two tables synchronization, How!
  
  by ptaylor · about 19 years ago
  
  In reply to Access two tables synchronization, How!
  
  Here is a Microsoft page that will help answer questions on how to automate replication. You do not state which version of Access. The information was retrieved for Access 2000.
  
  http://support.microsoft.com/default.aspx?scid=kb;en-us;282977
  
  Hope this helps to answer your questions.
  - May 11, 2003 at 11:26 pm #3358280
    
    Access two tables synchronization, How!
    
    by techrerpublic · about 19 years ago
    
    In reply to Access two tables synchronization, How!
    
    thks… for the KB (had it already Access 2k)… jet I was hopping for an querie script that willcompare the new with the old data and make the appropiated changes… between tables!
- May 11, 2003 at 11:56 pm #3358264
  
  Access two tables synchronization, How!
  
  by ptaylor · about 19 years ago
  
  In reply to Access two tables synchronization, How!
  
  The link I sent shows scripts in the information. To syncronize in a single direction you will use:
  Replica.Synchronize(Target [, SyncType] [, SyncMode])
Author

Replies

Viewing 1 reply thread

Start or Search

Start New Discussion

Recruiting an Operations Research Analyst with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job.This hiring kit from TechRepublic Premium includes a job description, sample interview questions ...

The digital transformation required by implementing the industrial Internet of Things (IIoT) is a radical change from business as usual. This quick glossary of 30 terms and concepts relating to IIoT will help you get a handle on what IIoT is and what it can do for your business.. From the glossary’s introduction: While the ...

Procuring software packages for an organization is a complicated process that involves more than just technological knowledge. There are financial and support aspects to consider, proof of concepts to evaluate and vendor negotiations to handle. Navigating through the details of an RFP alone can be challenging, so use TechRepublic Premium’s Software Procurement Policy to establish ...

Software

General discussion