I am wondering if it is good practice to have separate databases for a database as a whole. one that holds all tables and another or multiple others to hold reports, queries, and forms. those possibly divided depending on the users that need access to the different forms and reports.
I am trying to design a database that will have many different sections for our production facility. There will be a supply inventory section, a test equipment section, a production section that has different focus areas on what they produce, a testing section and the HR (administration) section.
I am wanting to get this designed properly the first time to avoid making too many changes to the structure later.
Any help on this subject would be greatly appreciated.
Thank you for your time and input,
Walker