Protecting the code

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Is it possible to password protect all the things you
dont want users to get to? I'm thinking the design views
for forms and the modules of code that reside in the
database?

I need a way to do this: I've just sent out an app for
use with bullet proof instructions for a users to get in
to try and make 'improvements' only to bugger things up
good and proper.

TIA
Tim
 
Easiest way is to make your app into an MDE file, and if
it's not split into Front End (everything except tables) and
Back End (tables only) then do so. FE should be an MDE.

Alternatively you can use Access own security, workgroup
file and so on - I'm not familiar enough with Access
security to advise on that.
 
From Access 2000 and later, you can add a password that will protect the
code modules. Go to Tools ... Properties ... the the Protection tab. Like
any password, it can probabbly be cracked by someone who is determined.

If you create an MDE file, the code is removed from the database and
tokenized. No one can get in, not even you, so it is important to have a
backup MDB file.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Tim said:
Is it possible to password protect all the things you
dont want users to get to? I'm thinking the design views
for forms and the modules of code that reside in the
database?

I need a way to do this: I've just sent out an app for
use with bullet proof instructions for a users to get in
to try and make 'improvements' only to bugger things up
good and proper.

TIA
Tim
Click to expand...

In addition to the suggestions made, If you buy the developers program
you have even more options for distribution.
 
Normally, you can use a mde, and also hide all of the ms-access interface
(you don't need security to do this).

Try downloading the 3rd example here:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

If you run the above example, you will notice that all of the ms-access
interface is hidden, and I did not have to use any code, or setup security
(all of the options I used are available in tools->startup).

So, give the above a try..and see if you can "get in" to the ms-access
interface.
 
Back
Top