Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: Resty Jr Masilungan
  Where is Resty Jr Masilungan?
 Quezon City
 Philippines
 Resty Jr Masilungan
 Tags
Subject: RE: Better Multiuser Approach?
Thread ID: 112501 Message ID: 112534 # Views: 4 # Ratings: 0
Version: Visual FoxPro 6 Category: Visual Basic
Date: Thursday, November 09, 2006 1:05:29 PM         
   


> I would suggest you do the the main server approach but having 3 departments meaning having also 3 heads. If that would be the case.
>
> Have a backup of each data per department on each head computer. That way you will not loose any data if ever the server crashes.
>
> Better Safe than sorry.
>
> But the update be done on a scheduled daily basis.
>
> The actual data access should be done on the main server still.
>
> Hope this helps...
>
> Resty...
> Mabuhay.Philippines.Mabuhay.Foxite


Resty,

In a LAN environment, you could use insert and update triggers to update the local tables as the changes occur, but that would be a great deal of work and for what benefit? A Dept. Head can use a parameterized query to see only his/her data. It would not be very good as a backup either. If the server fails, I am going to go directly to my backup tapes/cds/dvds etc. before I go to another computer. Lets face it, if the server goes, I am going to need to restore much more than just the data from this app.

If you were talking about a remote site or a laptop app where the user may not always have the ability to be connected, then go ahead and store the data locally as well, but syncronizing two databases is not something to be taken lightly. In a remote or laptop app, there is a benefit to offset the cost of the synchronization routine. In a LAN environment there is no benefit.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

Better Multiuser Approach? Posted by kulwant singh @ 11/9/2006 6:37:22 AM
RE: Better Multiuser Approach? Posted by Bernard Bout @ 11/9/2006 7:07:19 AM
RE: Better Multiuser Approach? Posted by kulwant singh @ 11/9/2006 7:30:51 AM
RE: Better Multiuser Approach? Posted by Ken Murphy @ 11/9/2006 8:06:18 AM
RE: Better Multiuser Approach? Posted by Resty Jr Masilungan @ 11/9/2006 10:42:20 AM
RE: Better Multiuser Approach? Posted by Ken Murphy @ 11/9/2006 1:05:29 PM
RE: Better Multiuser Approach? Posted by Bernard Bout @ 11/10/2006 10:38:50 PM
RE: Better Multiuser Approach? Posted by Bernard Bout @ 11/10/2006 10:35:34 PM