Lock Project for Viewing

  • Thread starter Thread starter BartD
  • Start date Start date
B

BartD

Is there a method available in Access 2002 for patching
an existing Access MDB file with module security set.

I need to patch a Access 2002 mdb file "numerous ones in
several countries" and releasing a CD with the full
application is not a good option. I can create a small
patch program which will replace a buggy form in another
Access mdb file but in Access 2002 when you lock the
Project for viewing you can't use the Transfer Database
method to pach the existing file. It tells you that you
have to unlock the modules to transfer the form.

This was not a problem in Access 97.
 
Well, the module password wouldn't be much use, if you could modify the
modules without actually knowing the password!

AFAIK, you will not be able to modify the modules while they are subject to
a VBA password.

Also, it sounds like you have maybe not split your application into a
front-end/back-end structure. The BE database contains all of the tables,
but nothing else. The FE database contains all of the queries, forms,
reports, macros & modules, and has links to the actual tables in the BE.
Then, if you need to modify your application, you just supply a new version
of the whole FE database.

It sounds like you have supplied your application as a single database, so
you can not give them a new copy, since that would wipe out all their data.

HTH,
TC
 
Back
Top