A family of Microsoft relational database management systems designed for ease of use.
You can insert the field Subproject Read only in a table view in a consolidated schedule. For the subprojects that you want to open when you open the consolidated schedule (master), set the field to no. Close the file reopen, then verify that someone else can open the files read/write when you have the master open. You can also put passwords for write access of individual files.