Software

General discussion

Gravatar
0 Votes
Locked

Access two tables synchronization, How!

By TechRerpublic ·
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.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Access two tables synchronization, How!

by ptaylor In reply to Access two tables synchro ...

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.

gravatar
Collapse -

Access two tables synchronization, How!

by TechRerpublic In reply to Access two tables synchro ...

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!

gravatar
Collapse -

Access two tables synchronization, How!

by ptaylor In reply to Access two tables synchro ...

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

Back to Software Forum

Start or search

Related Discussions

Related Forums