Copy Forms and Tables from Secure DB to other Secure DB

19 Dec 2006 9:33 PM

FL

I'm unable to import tables or copy forms from one secure DB to another
secure DB. I can access each DB separately. Maybe both need to be open.
I'll try this.

--
FL

19 Dec 2006 9:51 PM

Joan Wild

Sounds like you have two mdbs that are secured with two different mdw files.

You need to add the same user (same name and PID) to both mdw files, and
ensure that user has sufficient permissions in each mdb.

Note that when you import an object from a secure mdb, the permissions don't
travel with it. Actually the imported object will get whatever permissions
you have on the <New Tables/Queries> item.

--
Joan Wild
Microsoft Access MVP

FL wrote:

Show quoteHide quote

> I'm unable to import tables or copy forms from one secure DB to
> another secure DB. I can access each DB separately. Maybe both need
> to be open. I'll try this.
> --
> FL

19 Dec 2006 10:15 PM

FL

Hi Joan, Thanks for the quick reply. I just need the form to modify and
create a new one in the other DB. Yes, each DB has it's own mdw. They are
used by a different set of users. I'm admin for both. I've also imported
tables too but not from secure DB's. I guess I could go to my original
unsplit/unsecure DB that I originally used to develop and copy whatever forms
or tables I need. I just thought I could do this while using the two secured
DB's. I'm the "user"/admin person trying to copy these forms and tables. I
believe my PID's are different in each DB. I created security using DB
Wizard. Does this mean the PID's must be the same, for me, to be able to do
this DB structure copying between the two DB's? If I change my PID's to
match will I risk loosing access to one or both DB's as admin person?

--
FL

Show quoteHide quote

"Joan Wild" wrote:

> Sounds like you have two mdbs that are secured with two different mdw files.
>
> You need to add the same user (same name and PID) to both mdw files, and
> ensure that user has sufficient permissions in each mdb.
>
> Note that when you import an object from a secure mdb, the permissions don't
> travel with it. Actually the imported object will get whatever permissions
> you have on the <New Tables/Queries> item.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> FL wrote:
> > I'm unable to import tables or copy forms from one secure DB to
> > another secure DB. I can access each DB separately. Maybe both need
> > to be open. I'll try this.
> > --
> > FL
>
>
>

20 Dec 2006 3:42 PM

Joan Wild

If the PIDS are not the same, then the user isn't the same. You cannot just
change the PID. You'd have to delete the user and recreate it in the other
database.

Can you login to one and then hit Ctrl-O and open the other mdb? If not,
then the PIDs are different. If you used the wizard on each then likely the
PIDs are different.

One option is to create a totally new username; with the same PID in each
mdw. Then grant permissions on that username to the necessary objects in
the mdb(s).

Probably putting this user in the Admins Group would be sufficient - no
explicit permissions need be granted in the mdbs.

--
Joan Wild
Microsoft Access MVP

FL wrote:

Show quoteHide quote

> Hi Joan, Thanks for the quick reply. I just need the form to modify
> and create a new one in the other DB. Yes, each DB has it's own mdw.
> They are used by a different set of users. I'm admin for both. I've
> also imported tables too but not from secure DB's. I guess I could
> go to my original unsplit/unsecure DB that I originally used to
> develop and copy whatever forms or tables I need. I just thought I
> could do this while using the two secured DB's. I'm the "user"/admin
> person trying to copy these forms and tables. I believe my PID's are
> different in each DB. I created security using DB Wizard. Does this
> mean the PID's must be the same, for me, to be able to do this DB
> structure copying between the two DB's? If I change my PID's to
> match will I risk loosing access to one or both DB's as admin person?
> --
> FL
>
>
> "Joan Wild" wrote:
>
>> Sounds like you have two mdbs that are secured with two different
>> mdw files.
>>
>> You need to add the same user (same name and PID) to both mdw files,
>> and ensure that user has sufficient permissions in each mdb.
>>
>> Note that when you import an object from a secure mdb, the
>> permissions don't travel with it. Actually the imported object will
>> get whatever permissions you have on the <New Tables/Queries> item.
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> FL wrote:
>>> I'm unable to import tables or copy forms from one secure DB to
>>> another secure DB. I can access each DB separately. Maybe both
>>> need to be open. I'll try this.
>>> --
>>> FL