I would like to create 4 separate databases from one master

[DBCamden]

I have a large database of Purchase Orders
Orders can be placed by people in one of 4 departments

I would like to automatically make 4 separate databases (so each department can access their own) from the master

Is there a way to do this?

 

[grnzbra]

Are you trying to create one front end db and four back end dbs and each department cannot see the records of the other?

 

[KeithG]

I believe you want to split into an Be/FE with four different Front ends. Do you want all the users to share the data?

 

[DBCamden]

Thats exactly what I want to do (create four back end dbs so that each department cannot see the records of the other)

Many thanks

 

[Dreamweaver]

What about just using a login system so when an employee logs on it checks the department they belong to then filters all records that relate only to that department.

going the other way could get messy in that you'll need to connect to the backend db plus there's also things like Stock Items, Clients Details they would need to be added for all 4 backends Unless you use a 5th for cross related items but that would be dodgy plus a few more gotchas.

If it was me I'd go with a login that way you can easily calc things like inter Departmental performance ACT