Locking VBA/Module with password

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
While I understand that it would be a much larger file to distribute, can
you not just redistribute the entire database?
 
Back
Top