Disable code view...

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Is there a way to disable to code view to end users?

I would prefer that the end users not be able to view/access/edit code that
has been written.

Can access to the code be disabled?

Any help would be appreciated.
 
Joe said:
Is there a way to disable to code view to end users?

I would prefer that the end users not be able to view/access/edit code
that
has been written.

Can access to the code be disabled?

Any help would be appreciated.


The simplest way is to create an MDE or ACCDE file (depending on your Access
version and file format) for distribution to your users. Then the source
code will be stripped out, and they won't be able to view the design of
forms and reports, either -- at least not readily. Of course, you have to
keep your regular MDB or ACCDB file for any further development.
 
OK, so I am using Access2003 and I tried to make the MDE file, but I get a
message
that it failed to create the MDE file.

What would cause the MDE file to not be created? Is there a process I should
run previous to making an MDE?

Thanks.
 
Joe said:
OK, so I am using Access2003 and I tried to make the MDE file, but I get a
message
that it failed to create the MDE file.

What would cause the MDE file to not be created? Is there a process I
should
run previous to making an MDE?


Run through the checklist here:

http://www.access.qbuilt.com/html/conversion.html

By far the most common cause is that the code contains errors that prevent
it from being compiled.
 
OK, so I am using Access2003 and I tried to make the MDE file, but I get a
message
that it failed to create the MDE file.

What would cause the MDE file to not be created?  Is there a process I should
run previous to making an MDE?

Thanks.






- Show quoted text -

Does it compile correctly?
 
An MDE /ACCDE is the most appropriate way, but I have had occassions where
my app did not run on an MDE (programatically designed Reports) ... so to
give a little bit of protection, without going with ULS, I just put a
password on the VBA project ...

While in the VBA editor,.... Tools -> <your VBA proj name> Properties ... a
dialog box pops up with General and Protection tab, in the Protection tab,
place a check mark in the "Lock project of viewing", then set and confirm a
password.
 
Back
Top