multiple workstations(seperate db) one master (sees all dbs)

[Andy]

I have senario where I need several workstations with duplicate databases
running
on different machines on intranet. I then need a master application which
veiws database records of all machines as if it were reading/editing one db.

what is the best way to do such a thing, will linking tables in the database
provide a solution??

 

[Jim Allensworth]

I have senario where I need several workstations with duplicate databases
running
on different machines on intranet. I then need a master application which
veiws database records of all machines as if it were reading/editing one db.

what is the best way to do such a thing, will linking tables in the database
provide a solution??

I'm assuming you mean LAN not intranet - which would imply browser
based applications.

You should split the application into Frontend (forms, modules,
queries, reports) and a Backend (just tables and relationships) that
is shared/linked to the frontends. Each station has a copy of the FE
that links to the single BE.

This way everything is in sych - all the data is realtime.

- Jim