Append 2 relational tables simultaneously

R

ryan_eng

Hey people,

I have created a simplified version of my database for employees off site to
record their hours. I created identical tables so that the data could be
transfered on a weekly basis to the master database through an append query
or something.

There are two tables involved, one has the date, employee ID and an auto ID.
The other is related through the first tables autoID and includes its own
autoID as well as all the details of the hours of that date.

How do I update the same tables in my master database, while maintaining the
relational data?

Thanks
RY
 
J

John Vinson

How do I update the same tables in my master database, while maintaining the
relational data?
Click to expand...

With great difficulty, since the disconnected databases might very
well have added two different records with the same autonumber value!

This situation is specifically the reason that Access includes
"Replication". Unfortunately database replication is a rather complex
process, and can easily be done wrong. Get the Replication whitepaper
from Microsoft's website:

http://support.microsoft.com/kb/282977/en-us

BACK UP YOUR DATABASE FIRST - replication makes some
difficult-to-remove changes - and study this document with care before
replicating.

Once you do, you can have two databases as you describe; they can be
synchronized either by bringing them onto the same LAN, or even be
synchronized over the internet. There's a Replication newsgroup if you
need specific help on the subject.

John W. Vinson[MVP]
 
Top