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

J

Jay

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

Jay

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,
 
L

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
 

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

Top