Oct 18 2011, 01:51 PM
I have a front end .MDB. It has a form called Form1
I copied it and tried to paste it in another, brand new .mdb file. I get the popup "microsoft protects this vba project with a password. you must supply the ......." (etc. etc. etc. ).
Yes the vba project is pw-protected in the source DB, but I've already gone in there - I've already expanded it - entered the password -etc - and the new one is NOT protected with a password.
Oct 18 2011, 01:54 PM
Not sure on the why ...
Have you tried opening the new one and importing the object?
Oct 18 2011, 02:02 PM
Once I removed the VBA password from the source mdb, yes, that worked to import them using File > Import.
Seems weird how I couldn't copy and paste, even with the source file open and already gone past the part where you expand the Project and enter the password. I guess it wanted the PW totally removed from source file, such as is required before importing.
I also tried to export something to my desktop, then import it to new MDB, ran into same issue.
Guess it's that the PW has to be removed before doing any of the above?
Oct 18 2011, 04:16 PM
When you password protect a database it also protects all objects in the database would be my understanding.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here