Massive Frontend

[DevastatioN]

Hello,

If you wish to design a front end that controls, let's say many backend individual databases, is this manageable?

Let's say I have 20 backend databases that I want controlled through a single frontend, would it be manageable as long as I had a specific prefix for each 'module' or 'section', such as frmADM, frmDOC, etc.

Because of all the password security and tracking this makes more sense than having different frontends etc. Currently the real system has 3 unique backends in it, but if this continues to grow I'm wondering on the managability.

Any suggestions?

 

[gemma-the-husky]

i have a standard accounting-type system. it deals with multi companies by letting you select the active company, and switching data files. Basically its a similar dbs, but the switch is done by checking the folder and file names, and reconnecting all the linked tables.

Sage in UK is the biggest SME software supplier, and they do something similar in theor multi company environment - they just duplicate the whole set of data/index/isam tables for each company, in a different folder