I have a mdb file that does not have database or user level security, but it does have a VBA password.
I want to transfer (overwrite) a new form to this database from another Access database. The form I'm exporting has VBA code. When I try using docmd.TransferDatabase I get an error. The error is:
"The TransferDatabase action was canceled."
The line is:
DoCmd.TransferDatabase acExport, "Microsoft Access", txtCheckInFile, acForm, "SubformLineSummaryContractor", "SubformLineSummaryContractor", False, False
where txtCheckInFile is the location and mdb file name I'm trying to send the export.
It might be because the form already exists. So, if I go into the database and delete form, and repeat the export 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."
My question is it possible to transfer a form to a MDB that has a passworded VBA? I know the VBA password.
If not, perhaps it is possible to remove the VBA password in the database (using VBA), make my export, and then add the password back in?
Thanks,
Leif
I want to transfer (overwrite) a new form to this database from another Access database. The form I'm exporting has VBA code. When I try using docmd.TransferDatabase I get an error. The error is:
"The TransferDatabase action was canceled."
The line is:
DoCmd.TransferDatabase acExport, "Microsoft Access", txtCheckInFile, acForm, "SubformLineSummaryContractor", "SubformLineSummaryContractor", False, False
where txtCheckInFile is the location and mdb file name I'm trying to send the export.
It might be because the form already exists. So, if I go into the database and delete form, and repeat the export 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."
My question is it possible to transfer a form to a MDB that has a passworded VBA? I know the VBA password.
If not, perhaps it is possible to remove the VBA password in the database (using VBA), make my export, and then add the password back in?
Thanks,
Leif