Locking VBA/Module with password

G

Guest

I have a stand alone database (A.mdb) that is used by different users on
different sites. It is password protected and has the vba modules protected
by password. When I need to update the database, eg a new version of a form,
I send an empty database to each user who opens a form in A.mdb that runs a
routine that deletes the old form and imports the new one.

This has worked fine until I recently locked the VBA code in A.mdb by
password. The import won’t work unless I supply the VBA password. Is there
anyway of programmatically getting around this as I don’t want to divulge the
VBA password?
 
D

Douglas J. Steele

While I understand that it would be a much larger file to distribute, can
you not just redistribute the entire database?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA/Module password 1
VBA Password 1
how do i bypass an access module password 1
Open a file mdb with a password 1
open a password protected database with vba code using ecxel as fr 1
Security - VBA Password 3
Excel VBA Project Has Protection? 2
Visual Basic for application Project Password Problem!! Help!! 1

Top