Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 To: Kulwant Singh
  Where is Kulwant Singh?
 Shimla
 India
 Kulwant Singh
 Tags
Subject: RE: Better Multiuser Approach?
Thread ID: 112501 Message ID: 112678 # Views: 3 # Ratings: 0
Version: Visual FoxPro 6 Category: Visual Basic
Date: Friday, November 10, 2006 10:35:34 PM         
   


> > > Hello all,
> > >
> > > Thanks for your help with my previous postings.
> > > Can someone please guide me regarding:-
> > > How to go about automation of an organisation with three Departments in the same building (on Lan).
> > >
> > > Approach One.
> > > Keep Data at one cpmputer. Other computers Access 'this' computer for the transactions.
> > >
> > > Approach Two.
> > > Keep independent Data at each computer. At Day close : Gather and consolidate data from all Nodes.
> > >
> > > Which approach should be adopted? What are the Pros and Cons of each? Are there other better alternatives?
> > >
> > > Thanks!
> > > kulwant

> >
> >
> > There is no question in my mind. 3 departments close to each other. The first is te way to go. That way everyone has and works with live data.
> >
> > Approach Two involves too much compilcation to even contemplate. Forget it. Keep your data as live as is possible always.
> >
> > IMHO

>
> Thank you Sir,
> Would your answer be any different considering:
> All three departments are selling different products, with no concurrency issues involved.
> The only need for consolidation is that the management needs a a Consolidated/Summarised report of preceedings at each Department.
>
> thanks!
> kulwant


HI Kulwant

No. Never. I am working in an environment with 34 different clubs across Australia each with their own user base, product etc. and the data is all consolidated into 1 database. If I need to send data to a particular club, then my select will use a filter, as Ken suggested, to only send products being sold by that company to that company.

Heed Ken's words:

This could get very cumbersome very quickly!!

You are not thinking of the future. Bulk updates are not necessary in these days. The data can be anywhere. It is up to the developer to present the correct data to the user. Plus as Ken said there are the problems of consolidation, data that is not live, multiple backups etc etc etc.

Bulk updates were used ages ago when communications were not at the standard they are now. There is no need now to follow this path.

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