Combining 2 databases into 1

I have a large database of client info. 3 different
offices will use the database, but they are not connected
and no web access. The databases must all be updated
frequently so that they all have the same info.

I've read all the help screens, but they all talk about
importing/exporting and what I need to do is
combine/update. But since they're in separate database I
don't think I can do an update query.

How do I accomplish what I need? Thanks for any advice.

P.S. I know this is not the best way to handle databases
but, it's what we have so I have to go with it.

Look into "Replication". This is a built-in feature of Access that will
help you synchronize the information in your databases. Allison Balter has
written several good books that cover this topic pretty well. Look on
Amazon or in your bookstore for one of those.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Betsy" wrote in message
...
I have a large database of client info. 3 different
offices will use the database, but they are not connected
and no web access. The databases must all be updated
frequently so that they all have the same info.

I've read all the help screens, but they all talk about
importing/exporting and what I need to do is
combine/update. But since they're in separate database I
don't think I can do an update query.

How do I accomplish what I need? Thanks for any advice.

P.S. I know this is not the best way to handle databases
but, it's what we have so I have to go with it.

On Mon, 7 Jun 2004 09:14:34 -0700, "Betsy"
wrote:

I have a large database of client info. 3 different
offices will use the database, but they are not connected
and no web access. The databases must all be updated
frequently so that they all have the same info.

I've read all the help screens, but they all talk about
importing/exporting and what I need to do is
combine/update. But since they're in separate database I
don't think I can do an update query.

How do I accomplish what I need? Thanks for any advice.

P.S. I know this is not the best way to handle databases
but, it's what we have so I have to go with it.

The best solution I can think of is to use "Replication". This takes a
fair bit of work to set up, but it does allow unconnected databases to
be kept in synch. See the Replication FAQ at
http://support.microsoft.com/default...pl/replfaq.asp
and also Michka's excellent coverage of the subject at
http://www.trigeminal.com/usenet/usenet.asp?1033. Study the FAQ
*carefully* - replication can be very useful but it can also be a
mare's nest of complications.


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Hi Betsy,

It looks like you've already received some advice from Roger Carlson and John Vinson regarding
the use of replication. That's good advice for the future to help prevent your current problem.
However, to answer your specific question, you might want to review some information that Danny
J. Lesandrini has posted:

http://www.amazecreations.com/datafa...emerge2dbs.asp


Tom
________________________________________

"Roger Carlson" wrote in message
...

Look into "Replication". This is a built-in feature of Access that will
help you synchronize the information in your databases. Allison Balter has
written several good books that cover this topic pretty well. Look on
Amazon or in your bookstore for one of those.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org
________________________________________

"Betsy" wrote in message
...

I have a large database of client info. 3 different
offices will use the database, but they are not connected
and no web access. The databases must all be updated
frequently so that they all have the same info.

I've read all the help screens, but they all talk about
importing/exporting and what I need to do is
combine/update. But since they're in separate database I
don't think I can do an update query.

How do I accomplish what I need? Thanks for any advice.

P.S. I know this is not the best way to handle databases
but, it's what we have so I have to go with it.