Import objects from secured db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PHisaw - 06 Jul 2007 15:46 GMT

Hi,

I have two secured db's. I am set up in the Admins, Full Permissions and
Users groups. I am trying to import or copy items from one db to another and
keep getting error msg that I don't have permission to use db object. I
don't really want to remove all security if I don't have to because I will
replace old db with this revised version.
Can someone tell me what I need to do to make this work?

Thanks for your help,
Pam

Reply to this Message

Joan Wild - 06 Jul 2007 17:18 GMT

You need to either
1) add the same user (using the exact same name and PID) to both mdw files and grant this user permission to open the database object and read data on the tables.
or since it sounds like a one-off thing,
2) temporarily grant the Users Group permission to open the database object and read data permissions on the table(s).

Note that when you import objects, their permissions won't travel with them, so be sure to set the permissions after imported.

Signature

Joan Wild
Microsoft Access MVP

> Hi,
>
[quoted text clipped - 7 lines]
> Thanks for your help,
> Pam

Reply to this Message

PHisaw - 06 Jul 2007 18:02 GMT

Hi Joan,

Thank you for your reply. I created both databases I'm trying to copy
to/from. Our IT dept set up the db security, so even though I've worked with
db's for some time (and am always learning something new thanks to everyone's
valuable input here), I've never until this past year had a reason for db
security. That being said, all this is slightly confusing. As stated, I am
in the full permission, user and admin group. When I go to
Tools>Security>Permissions and click a specific query to copy with my name
highlighted, all boxes are checked. I'm still not understanding why it won't
let me copy or import my front-end items from one db to another when I'm
logged in as user to both or what exactly I need to do to make it happen.

Hoping you will explain further.
Thanks again for your help.
Pam

> You need to either
> 1) add the same user (using the exact same name and PID) to both mdw files and grant this user permission to open the database object and read data on the tables.
[quoted text clipped - 14 lines]
> > Thanks for your help,
> > Pam

Reply to this Message

PHisaw - 06 Jul 2007 18:56 GMT

Joan,

I finally got it to work. Thanks for your help - greatly appreciated!!

Pam

Reply to this Message