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