Linking Two Databases Together 1

[zephaerie]

Okay, here's the deal:
We have an Excel Spreadsheet that is saved on an internal server. Our group has been requested to save a back-up copy to our respective personal hard-drives, in case the server fails. Is there any way to link the two documents so that when one is saved, the other is updated?

 

[Harlequin007]

Zeph.

I don't know about anyone else - but I'm sure you'll get to find out rather quickly but I would not recommend this course of action.

Possible solution:

Split the DB and have a front-end working on everyone's PC that needs it. Have the back-end on the server.

Then have a batch file that is auto executed every 30 minutes or so that grabs a copy of the back-end and places a copy on another PC, or PCs.

There are lots of other ways of tackling this but I would definately not use the option you have been asked to investigate. I have lost data that way.

"A wise man learns from other people's mistakes while the fool makes his own"

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[zephaerie]

Your suggestion worked perfectly. Thanks again!