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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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,
 
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
 
Back
Top