Combine 2 secure databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 02 Mar 2005 02:33 GMT

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.

Reply to this Message

Rick Brandt - 02 Mar 2005 03:01 GMT

> 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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message