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

19 Sep 2006 8:14 PM

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.

--
Jay

19 Sep 2006 8:18 PM

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

Show quoteHide quote

"Jay" <gunderj@ommunity.nospam> wrote in message
news:1483046C-C317-4D4B-BE53-524B96FDAF70@microsoft.com...
> 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.
> --
> Jay

19 Sep 2006 9:31 PM

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,

--
Jay

Show quoteHide quote

"Jay" wrote:

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

20 Sep 2006 1:03 AM

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

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Show quoteHide quote

"Jay" <gunderj@ommunity.nospam> wrote in message
news:BECD3364-2D0C-4CD6-9393-84D57FC20081@microsoft.com...
> 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
>
>
> "Jay" wrote:
>
>> 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.
>> --
>> Jay