Import from a secure DB

F

FL

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

Rick Brandt

FL said:
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.
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a new DB by importing from another DB 0
Create a new DB by importing from another DB 1
Importing data from one DB into another DB 1
Access security behavour 3
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
secure new FE after import 4
Import to several tables in one process 6
Q.) Jet DB error: Multiple Users able to write to MS Access DBsimutaneously? 3

Top