I don't think this is the right forum for your question but I don't fully understand exactly what you are asking.
As I understand it, you have an organizational hierarchy distributed database managed by an application. Each database copy has identical schema. The Admin user has the complete database, Admin Users are given a subset with data for their Users
and normal Users will have only their personal data. The databases are disconnected from the network and maintained independently.
Is your goal to have the Admin provide each Admin User with a database containing their appropriate subset and then have the Admin Users provide normal Users with their personal subset? Will the database completely replace the existing one or
does existing data need to be merged? Will Admin Users/Users provide their updated database back to Admin/Admin Users and will that replace existing data or be merged?
You could use SQL Server backup/restore or detach/attach as part of a solution. For example, the Admin user (perhaps via the application) could create a staging database for each Admin User and populate it using queries that select only
the appropriate data. Each Admin User database can then be backed up or detached and given to the Admin users for restore or attach. Same approach for the Admin User and User databases.
Dan Guzman, SQL Server MVP, http://www.dbdelta.com
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.