AnsweredAssumed Answered

Multiple Databases Needed?

Question asked by Christian on Sep 10, 2012
Latest reply on Apr 24, 2013 by Christian


Multiple Databases Needed?


     Hi Eveyone,

     I work for a college within a university.  Under the college "umbrella" are different departments/schools.  We currently have ONE database of all faculty and staff members within each department/school.

     I am currently restructuring that database to make it more useable and want to begin making it accessible via the web, and viewable/editable only by department heads.  The thing is, each department should have access to only their respective faculty/staff data.

     What is the best way to accomplish this?  I was thinking of creating a separate database within the Peronnel file for each department/school, and restricting access to only their department heads.  Would this be a "best practices" way of doing things?  If so, how do I import my information from the current ONE database into the separate databases of the departments/schools?

     Please let me know if I need to clarify.

     Thank you for any input!