Importing Forms with VBA password

[mergle]

I am trying to import an updated form from a VB protected db... the File>Get External Data menu gives me a dialog box that says I need a password...there is no input box/prompt for me to enter the password...How to do?...Can you open two (2) db's at same time??

Thanks in advance!

 

[smubbel]

If the destination database is not password protected you can export selected items (forms,reprots,modules) directly from the source database.
However if both databases are password protected you will find yourself in a Catch-22 situation.
You will need an intermediary scratch database (I call mine ImportExport.mdb).
Works like this::
- create a new, empty Access database
- open the database you want to export items from
- select the modules/forms/reports you need
- rightclick and export the items to the ImportExport database
- use the ImportExport database to import items from
Good luck!