Software

Ask something
Discussion Locked

Access two tables synchronization, How!

0 helpful
3 replies

by techrerpublic

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by techrerpublic

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!

by ptaylor

The link I sent shows scripts in the information. To syncronize in a single direction you will use:
Replica.Synchronize(Target [, SyncType] [, SyncMode])

This discussion is closed to new replies.