how to import form,report or module objects with project security

[Guest]

Is there a way to supply the password in VBA code to allow an mdb file to
import objects from another mdb file?
My issue is if my mdb has project security turned on and tries to import
objects from another mdb file, I get the message,
"Microsoft helps protect this Visual basic for Applications Project with a
password. You must supply the password in the Visual Basic Editor before you
can perform this operation"
I would like to avoid this message, hopefully I could supply the password in
the VBA import code or some other work-around.
The import code is the docmd:
DoCmd.TransferDatabase acImport, "Microsoft Access", patchDir & fileName,
acForm, objectName, objectName
I cannot use the mde file to achieve project security - mde does not allow
the import at all.
Thanks vey much.

 

[David Pawloski]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

David Pawloski
Microsoft MVP

 

[Guest]

Thanks David, I am not sure if your discussion applys to my issue though. My
issue refers to avoiding a project security message box, not an image import
dialog.
Are you saying they are the same?
Thanks again,

 

[Lynn Trapp]

Jay,
Don't pay attention to this David Pawlowski character. There is no such
thing as Access 2004 and he is also not a Microsoft MVP