Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009


    I try to transfer some forms and some module from one database to another database, the code that I use in VB6 enviroment is:

    Dim appBD As Access.Application
    Set appBD = New Access.Application
    appBD.AutomationSecurity = msoAutomationSecurityLow
    appBD.OpenCurrentDatabase ("C:\Bar\MDB\Base1.mdb")
    appBD.DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\Bar\MDB\ProteccionBase\bd2.mdb", acForm, "Bienvenido", "Bienvenido", False

    If I use this code to tranfer tables don't have any problem the problem is when I try to transfer forms or modules and the modules in the VBA enviroemnt have password protection.

    How I set the password in VBA to allow the transfer

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    You can't, I'm afraid.
    Maybe you should try using the undocumented TransferText function, but I'm not sure it would work.

    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts