By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,395 Members | 1,391 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,395 IT Pros & Developers. It's quick & easy.

Multiple clients (seperate db) one master (sees all db's)

P: n/a
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??

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I wouldn't recommend this, but you could create a UNION query
that used UNC paths in the SQL to grab data from every computer.
I'm not certain, but my guess is that it won't be updatable and it
would be dog slow, but it would be the most current overall data.
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"Andy" <no**@none.com> wrote ...
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??

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.