Combine 2 secure databases

[David]

I have two simple databases that I want to combine.
They each have their own security file (mdw).
How can I combine them so that only one security file is needed?
When I open one then try to import from the other, I get the message that I
don;t have the privledge.

 

[Rick Brandt]

I have two simple databases that I want to combine.
They each have their own security file (mdw).
How can I combine them so that only one security file is needed?
When I open one then try to import from the other, I get the message
that I don;t have the privledge.

Open one as an administrator and grant full permissions on all objects to the
Users group. That should allow you to import all the objects into the other.
The objects will be owned by the account you use when doing the import and they
will have whatever permission "New" objects of each type get by default. Any
security settings beyond that will have to be set manually.