Hi guys,
I asked a question a while ago about maintaining a single or separate databases, etc and got some really good feedback; many thanks for this.
This question is an extension to the original question in that...
...We run two independant UK companies (separate company numbers), one is a recruitment agency, the other a specialist recruitment agency.
All our staff (including myself), work for both companies throughout the day...the amount of time spent on each being dependent on the needs of each business, etc....
We run two separate Access databases...and I guess you all know where I'm going with this...
Is there a legal requirement to have separate databases because they are separate companies? Or can I run a master single database? (as suggested in my original question, way back) - i.e. a single common backend which holds data from both companies, however the front end controlling what happens to the data (i.e. separate reports for each company (for tax purposes), with combined reports to see the overall financial position if needs be)
Any comments, ideas or personal experiences would be greatly appreciated. I'm hoping some of you may have legal knowledge regarding company law with regards to RDBMS systems, data protection, etc, etc
Many thanks in advance
Darren
I asked a question a while ago about maintaining a single or separate databases, etc and got some really good feedback; many thanks for this.
This question is an extension to the original question in that...
...We run two independant UK companies (separate company numbers), one is a recruitment agency, the other a specialist recruitment agency.
All our staff (including myself), work for both companies throughout the day...the amount of time spent on each being dependent on the needs of each business, etc....
We run two separate Access databases...and I guess you all know where I'm going with this...
Is there a legal requirement to have separate databases because they are separate companies? Or can I run a master single database? (as suggested in my original question, way back) - i.e. a single common backend which holds data from both companies, however the front end controlling what happens to the data (i.e. separate reports for each company (for tax purposes), with combined reports to see the overall financial position if needs be)
Any comments, ideas or personal experiences would be greatly appreciated. I'm hoping some of you may have legal knowledge regarding company law with regards to RDBMS systems, data protection, etc, etc
Many thanks in advance
Darren