How do I connect access databases saved on 3 different drives?

[Guest]

I have an access database saved in three different places. How do I network
these databases so that when I make changes in a database open from one
place, it updates the database in all three?

Thanks!

 

[Joseph Meehan]

I have an access database saved in three different places. How do I
network these databases so that when I make changes in a database
open from one place, it updates the database in all three?

Thanks!

You should not even be trying.

You need ONE database housing the data. That becomes your back end
database. Then you make one or more versions of a front end database and
each person gets a copy of the front end. The back end generally has all
the tables, and the front ends have queries, forms and reports. The front
ends do not store data they only link to the single back end so everyone is
using the same data.

It is called splitting the database and Access has a wizard to help you
set it up. You do need all those computers linked to the server that housed
the back end via a good LAN.

 

[John Vinson]

On Thu, 3 Aug 2006 13:40:02 -0700, Angie B <Angie

I have an access database saved in three different places. How do I network
these databases so that when I make changes in a database open from one
place, it updates the database in all three?

Thanks!

You can't, not as you describe it.

Are these three places all on the same fast, stable LAN? If so, you
can store the tables in a shared folder, and link to them from the
three databases.

If they are at remote locations (another building, another town,
another continent) then you'll need to use Replication. It's a complex
subject - get the Replication Whitepaper from
http://support.microsoft.com, search for Access 2000 Replication - and
study it CAREFULLY. There's more information at
http://www.trigeminal.com on the subject.


John W. Vinson[MVP]