Ben,

I definitely think you CAN separate clients into their own files.

Lester Caine makes an excellent point in his message, though - If you need
to perform calcuations using the data of multiple clients, you would need to
use some type of an engineered solution to aggregate the data from multiple
files.

Best Regards,

David Montgomery
montgomery@...

> -----Original Message-----
> From: Ben Johnson [mailto:ben_johns@...]
> Sent: Saturday, February 16, 2002 6:22 PM
> To: ib-support@yahoogroups.com
> Cc: lester@...
> Subject: Re: Re: [ib-support] WHICH ONE IS BETTER
>
>
>
> Hi,
>
> Thanks for your valuable reply.
>
> The main 2 tables can grow upto 150,000 for a financial year
> (March-April).
> 7 financial years data of each client has to be kept in the database.
>
> Processing activity occurs only at financial year end while generating
> reports, otherwise just data entry only. Only 4-5 clients accounts will
> be active at a time.
>
> No plan for replication and shadow files.
>
> Considering all this I think I can go for seperate database files for each
> client. PLEASE LET ME KNOW YOUR OPINION?
>
> Thank you very much.
>
> Ben
>
>
> On Sat, 16 Feb 2002 lester@... wrote :
> > An easier question to answer.
> >
> > Do you need to do ANY calculations that involve more
> > than
> > one customer?
> >
> > If a lot are needed, then go for one database.
> >
> > If you only need to bill them <g> then create a database
> > with the billing information, and separate databases for
> > each client. Then when you select a new client, you just
> > change your login for the private stuff. I use
> > IBObjects and
> > just load a new database path in my case, for each
> > station,
> > and each of them are on other machines as well!
> >
> > Backing up all those files can be a problem, but all you
> > have to do is set up a gbak command line command and
> > populate it from a scan of the billing database. ( We
> > only
> > restore now ocasionally, but this could be automated as
> > well
> > )
> >
> > --
> > Lester Caine
> > -----------------------------
> > L.S.Caine Electronic Services
> >
> > ------------------------ Yahoo! Groups Sponsor
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com