How do I link multiple databases on the same server?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We use one main database and want to be able to share it between five of us.
We each have our own client table which feeds in to a main client table. We
would like to be able to set up links between each database so that
everything updates automatically.

i.e. Main database is called "Clients" and is stored on our shared drive.
We each have our own folders on the shared drive with a copy of the same
database in.

So far, we have only been able to link two of them together. How can we add
the rest in and make them work please?

I am a mere mortal and not a techie so please be gentle with me:)
 
Have you tried using replication. There are may postings in this newsgroup
and you can google it too.
 
Hi Kath,

The usual technique is to split the main database so that all the tables
are in one "back end" .mdb file on the shared drive, while the "front
end" - all the forms and queries and reports and so on - is in a
separate .mdb file with linked tables connected to the "real" tables in
the back end. Each user should have their own copy of the front end,
preferably on their workstation's hard drive.

See http://allenbrowne.com/ser-01.html and Access Help for more.

On Thu, 22 Feb 2007 15:18:43 -0800, Kath Roberts <Kath
 
Thank you John

I will try this today.

Kath

John Nurick said:
Hi Kath,

The usual technique is to split the main database so that all the tables
are in one "back end" .mdb file on the shared drive, while the "front
end" - all the forms and queries and reports and so on - is in a
separate .mdb file with linked tables connected to the "real" tables in
the back end. Each user should have their own copy of the front end,
preferably on their workstation's hard drive.

See http://allenbrowne.com/ser-01.html and Access Help for more.

On Thu, 22 Feb 2007 15:18:43 -0800, Kath Roberts <Kath
Click to expand...
 
Thanks Eric

I will have a go later today.

Kath

Eric Blitzer said:
Have you tried using replication. There are may postings in this newsgroup
and you can google it too.
Click to expand...
 
Back
Top