Provide VBA Password Programmatically

  • Thread starter Thread starter Jake
  • Start date Start date
J

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
 
Jake said:
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
Click to expand...

take a look at this :
http://support.microsoft.com/defaul...port/kb/articles/q147/8/16.asp&NoWebContent=1
 
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
 
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
 
Back
Top