Can you duplicate an entire database?

[mgxdigital]

I'm wondering if it is possible to duplicate an entire database?

The company that I work for deals with paper sales in rolls and sheets. Right now we have everything in one database and I would like to copy it so that we can have a rolls database and a sheets database that can still talk to eachother. But they need to be seperate because there are 2 different locations working on them. So we do not want the roll guys to have to deal with anything sheets related and vice versa.

But we have seperate databases tied into the big one we have now (i.e. our invoice database) that draws from both sides, so we want that to be able to work as usual.

Any suggestions?

Please!

Edited February 10, 2009 by Guest

[David Jondreau]

You don't want separate databases. You want a properly designed one. There are several ways to limit what records a group of people see.

The simplest and most secure is to use Access Privileges, though there may be interface issues (depending on your table and layout structure). Assign the users to either a Roll privilege set or a Sheet privilege set and limit record access so that Rolls only see Roll records and vice versa.