Proper way to import objects

[Daniel Pineault]

I have recently experienced major issues importing objects from one secured
db into another, so much so that the imported objects will not display and I
am in the process of having to recreate them.

Is there a proper method of importing object so that they take on the proper
permissions? In the security dialog everything is fine (proper permissions
are set), but in runtime they do not display.

Thank you for your help,

Daniel Pineault

 

[Joan Wild]

Daniel, when you import objects, the permissions do not travel with the object. They instead will get the permissions you have set in the new mdb for 'New Tables/Queries, New Forms, etc.'

You might find Jeff Conrad's utility helps in transferring the permissions. First item at http://www.accessmvp.com/SDaigle/index.htm


--
Joan Wild
Microsoft Access MVP
:I have recently experienced major issues importing objects from one secured
: db into another, so much so that the imported objects will not display and I
: am in the process of having to recreate them.
:
: Is there a proper method of importing object so that they take on the proper
: permissions? In the security dialog everything is fine (proper permissions
: are set), but in runtime they do not display.
:
: Thank you for your help,
:
: Daniel Pineault
: