to replicate or not?

[qwkslvr1999]

I have a database that used to be on a network drive but I was always getting a disk error (the other users as well) everytime the database is left open and not do anything. To isolate the problem, I decided to transfer it to my local drive.

I haven't been getting any errors and the db seems to work fine. I am the only one who will make changes to the db and the other users will only need to view the data.


I first thought of using replication to resolve my issue. But would it be the practical way? What about just copying my database back to the network and have them copy it to their local drives (maybe by using batch files)?

Thanks in advance for your input/s!

 

[Crilen007]

I have everyone with a local copy, and have them linked to just a DB with tables on the network.



If i make a change, i wrote a small VB program to update thier databases when i make a chance.

 

[qwkslvr1999]

Thanks! I actually did that before but it slowed down the database sooo much.