Hello Martijn

No, each Company is totally independent from the others.

Greetings.

Walter.

On Wed, Jan 18, 2012 at 6:29 AM, Martijn Tonies <m.tonies@...>wrote:

> **
>
>
> Hi,
>
>
> > I need to make an application that will be used by an accounting study.
> > They have too many clientes, so my question is:
> > - Is it better to have just one .FDB file and in each table add a column
> > "Company Name"? or ...
> > - Is it better to have a .FDB file for each Company?
> >
> > If I have a .FDB file for each Company:
> > -------------------------------------------------------
> > - Data will be separated, no chance to unintentionally merge them
> > - The backup will be more complicated, because they will need to make
> 150,
> > 200, 300, or more backups
> > - It will be much more complicated to update the metadata, because they
> > will have 150, 200, 300 or more .FDB files
> >
> > So, somebody had passed for a similar situation? What's your advice?
>
> Do you require queries - for any purpose - to run across "companies"?
>
> If so, that settles it, unless you want to use the route of Stored
> Procedures
> with remote connections.
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
>
>


[Non-text portions of this message have been removed]