I develop an access database with forms and VBA modules.
When I deliver this database, I would like that the users cannot
access to the code of these forms and modules (to avoid accidental
modifications).
So, before making the delivery, I protect the code by setting a
password to the VB project (properties protection tab). I do this on a
copy of the .mdb file, so as each time I develop I do not have to
enter the password to make modifications.
This is a very simple task, but since I use a VBScript script that
performs some
other tasks necessary for the delivery, I would like to include this
task in the script.
Since we can access to the VB project by automation with code like:
Set db = GetObject("DB.mdb)
MsgBox db.VBE.ActiveVBProject.VBComponents(1).Name
I am wondering if I can perform this password protection of the VB
project by automation.
Hope it's clear.
David.
d.***************@blueyonder.co.uk (David Schofield) wrote in message news:<416317e7.1041876699@localhost>...
On 4 Oct 2004 02:39:07 -0700, la**********@yahoo.fr (David LACASSAGNE)
wrote:
Is it possible to set a password to protect the code of an Access VBA
project by automation (I already know how to to it manually)?
David.
Hi
I suspect no-one has answered this because its not clear what you mean
David