> it would be much better C/S
> methodology to keep all data from all clients in the one database where
> table data has a field called e.g. client number. Your queries (in your
> application) would always ask, inter alia, for only "where clientno=999"
> for each request for data.
When we have done this in the past, we have used views, that way the "where
clientno=999" is in the view, not the client. So instead of "Select * from
Invoices" you would "Select * from CusA_Invoices"
It would be even easier if each 'client' has its own single login username,
and use the CURRENT_USER variable in the views.
Phil
--
Linux 2.4.4-4GB
11:12am up 40 days, 17:01, 1 user, load average: 0.18, 0.11, 0.03