Import from a secure DB

[Guest]

How can I create a new DB by importing from another DB that is secured? When
I do this Access says I do not have necessary permissions. However, I am the
administrator and designer of this secured DB (split DB). I'm trying to copy
the FE to solve another problem. What steps are necessary to properly import
from a secure DB (mdb) file? I wish Access would just prompt me for my
security password and open the DB for importing. But it does not.

 

[Rick Brandt]

How can I create a new DB by importing from another DB that is
secured? When I do this Access says I do not have necessary
permissions. However, I am the administrator and designer of this
secured DB (split DB). I'm trying to copy the FE to solve another
problem. What steps are necessary to properly import from a secure
DB (mdb) file? I wish Access would just prompt me for my security
password and open the DB for importing. But it does not.

You have to open Access using the same workgroup file as that used to open
the secured file, only you open the unsecured file instead. That will cause
to log in and THEN you will be able to do the import.