Simple way to lock code needed

[Guest]

What is a simple way to lock the code on my database? Using Access 2002.
Have VB and Macros that I would like to secure.

 

[Douglas J. Steele]

Create an MDE.

 

[Guest]

How?

Create an MDE.

 

[Douglas J. Steele]

Tools | Database Utilities | Make MDE

A few cautions.

Compile your database first to make sure there are no errors (It's on the
Debug menu when you're in the VB Editor)

Make sure your database is in Access 2002 format (the default with Access
2002 is actually Access 2000 format). To convert, Tools | Database Utilities
| Convert Database

Make sure you keep the original MDB file. It is not possible to convert an
MDE back to an MDB.

 

[Guest]

Thank you.

Tools | Database Utilities | Make MDE

A few cautions.

Compile your database first to make sure there are no errors (It's on the
Debug menu when you're in the VB Editor)

Make sure your database is in Access 2002 format (the default with Access
2002 is actually Access 2000 format). To convert, Tools | Database Utilities
| Convert Database

Make sure you keep the original MDB file. It is not possible to convert an
MDE back to an MDB.

 

[Guest]

After I compile the database and do all the this and then if I add more to
the database file do I go through this procedure again any time I add or
delete something in the .mdb file?

 

[Douglas J. Steele]

Depends what you mean by "add or delete something in the .mdb file"

If you're just talking data, then no, you don't need to do anything.

If you're talking changes to queries, forms, reports, macros or modules,
then yes, you'd need to recreate the MDE

 

[Guest]

You have answered my question perfectly, thank you. I did mean add and
delete forms etc. I kind of flip back and forth from creator of the database
to user of the database and can sometimes not be quite clear to all of you
experts, sorry I will try to remember this in the future.