Multiple Databases Needed?
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!