Disable code view...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 25 Apr 2008 01:53 GMT

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.

Reply to this Message

Dirk Goldgar - 25 Apr 2008 02:28 GMT

> Is there a way to disable to code view to end users?
>
[quoted text clipped - 5 lines]
>
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Joe - 25 Apr 2008 13:10 GMT

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.

> > Is there a way to disable to code view to end users?
> >
[quoted text clipped - 11 lines]
> forms and reports, either -- at least not readily. Of course, you have to
> keep your regular MDB or ACCDB file for any further development.

Reply to this Message

Dirk Goldgar - 25 Apr 2008 15:43 GMT

> OK, so I am using Access2003 and I tried to make the MDE file, but I get a
> message
[quoted text clipped - 3 lines]
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

mcescher - 25 Apr 2008 15:44 GMT

> OK, so I am using Access2003 and I tried to make the MDE file, but I get a
> message
[quoted text clipped - 28 lines]
>
> - Show quoted text -

Does it compile correctly?

Reply to this Message

Brent Spaulding (datAdrenaline) - 29 Apr 2008 07:11 GMT

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.

Signature

Brent Spaulding | datAdrenaline | Access MVP

> Is there a way to disable to code view to end users?
>
[quoted text clipped - 5 lines]
>
> Any help would be appreciated.

Reply to this Message