>
> Helen,
> I try to clairly explain you what I would like to have:
> the problem is that I need for this strange arrangement since I have some

tables that are "common table" and some other that depends of kind of
"service" that has to be managed. So I have only one "master" db, and many
"Service" db, I don't know how many "Service" db I can have, but each
"Service" db will have all the master tables plus other tables. Again, all
the Sevice tables that refer to master, must contains the same data for all
the Service dbs. I have already created and tested an Delphi application
that works on a Access database. Using the linked table, I'm able to obtain
what I want, but since my database going to be "too big", you know that
access will become unuseful (performance very slow). So I'd like to migrate
to Firebird, but before that, I need to know if it meet to my aim. So, it's
possible to simulate the "access linked manager" with interbase or firebird?

> Many thanks
> Antonio
> ps: IBReplicator (or other similar tools ) I think can solve my broblem,

but I'd like to solve this problem via "query" if possible

As long as you don't need to enforce relationships internally in the
database, then you can link tables in separate databases all day long
without problems. I do this all the time. You just set up a database
connection for each database. Then just use normal queries tied to the
correct database. You can either provide your own mechanism for controlling
the linking, such as opening and closing the query while changing it's SQL,
or, if using Delphi or other language that has datasources, you can tie them
together using that as well.

Woody (TMW)

----------------------
"I don't know the key to success, but the key to failure is to try to please
everyone."
-Bill Cosby