How can I take data from 3 MS Access databases and combine it int.

[Guest]

I want to collect information at three different locations and enter it into
Access databases. Then, periodically, I want to combine that information
into one central database. How can I do that? Note: the different locations
are not networked and do not have have online access.

 

[John Vinson]

I want to collect information at three different locations and enter it into
Access databases. Then, periodically, I want to combine that information
into one central database. How can I do that? Note: the different locations
are not networked and do not have have online access.

Sounds like "Replication" is your best bet. See the Replication FAQ at
http://support.microsoft.com/default.aspx?scid=kb;en-us;282977

Study this document carefully. Replication can be pretty tricky. There
are some additional articles at MichKa's website www.trigeminal.com
which may be helpful.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps