I need to update data from two different databases.

[Guatemalan Project]

My people in Guatemala maintains a database of the project and they send it
to me on a monthly basis. In the USA I add to the database data about the
fundraising that I do. I put that data in a Sponsors table. It links to the
sponsoredshildren table. The people in Guatemala has to have that
information so that they can give the children the benefits authorized by the
sponsors.
How do I update the two databases, let's call them: Florida and Guatemala.
They have the same tables, and each table has the same variables.
(e-mail address removed)
www.guatemalanproject.com

 

[John Vinson]

My people in Guatemala maintains a database of the project and they send it
to me on a monthly basis. In the USA I add to the database data about the
fundraising that I do. I put that data in a Sponsors table. It links to the
sponsoredshildren table. The people in Guatemala has to have that
information so that they can give the children the benefits authorized by the
sponsors.
How do I update the two databases, let's call them: Florida and Guatemala.
They have the same tables, and each table has the same variables.

I would really suggest that you look into "Replication":

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

It's a complex subject, and you should study the FAQ document
carefully and perhaps also check out the advice at
http://www.trigeminal.com and on the
microsoft.public.access.replication newsgroup; but it's designed
precisely for what you're trying to accomplish.

John W. Vinson[MVP]