Provide VBA Password Programmatically

[Jake]

I'm trying to automate the updating of my frontends, and
have run into a bit of a snag - any time I attempt to
import a form, I receive an error stating that the VBA
project has been password protected and I need to provide
the password.

Both files (the source and the updating file) have
passwords on their projects. I'm assuming I need to use
Application.CurrentProject.OpenConnection(), but I'm not
entirely sure what the BaseConnectionString and UserID
would be.

Help, please????

Thanks!
Jake

 

[Pepito]

I'm trying to automate the updating of my frontends, and
have run into a bit of a snag - any time I attempt to
import a form, I receive an error stating that the VBA
project has been password protected and I need to provide
the password.

Both files (the source and the updating file) have
passwords on their projects. I'm assuming I need to use
Application.CurrentProject.OpenConnection(), but I'm not
entirely sure what the BaseConnectionString and UserID
would be.

Help, please????

Thanks!
Jake

take a look at this :
http://support.microsoft.com/defaul...port/kb/articles/q147/8/16.asp&NoWebContent=1

 

[Jake]

Pepito,

Thank you for your response, but I don't think I was
entirely clear in my request. The database is not
actually secured - only the VBA project has a password.
For my automation I delete the old object and import the
new object from another database, however the forms have
modules behind them, and the modules are protected with
passwords to the import fails. What I need is a way to
pass the VBA password to the update and updating databases
so that the object is imported.

Any help would be greatly appreciated!

Jake

 

[Pepito]

Ok now I see what you want to do.
But I don't know how to do this.
I hope you'll find the solution ;-)

Pepito