Hiding Functions

[Jim Franklin]

Hi,

Can anyone tell me what is the most effective way of hiding a function or a
class module whilst still allowing full visibility to the rest of the vba
code within an Access 2003 app.?

I am distributing an application to experienced Access users who are
familiar with coding in VBA. I need them to be able to see and edit the code
within the application, and to be able to call various functions, without
them being able to see the inner workings of those functions.

If this involves distributing additional files, this is not a problem. I
looked at workgroup security to restrict access, but the sad fact is that
workgroup files are just too easy to penetrate.

I hope I have explained effectively what I want and I appreciate any help
anyone can give,

Thanks,
Jim

[Douglas J. Steele]

You should be able to put the code you want hidden into an MDE, and then set
a reference to that MDE from within your MDB.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Jim Franklin" <byeby...@ntlworld.com> wrote in message
news:o%hLm.7130$Gd3....@newsfe16.ams2...

[Alex Dybenko]

Hi,
you can also consider building library DLL on VB6

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"Jim Franklin" <byeby...@ntlworld.com> wrote in message
news:o%hLm.7130$Gd3....@newsfe16.ams2...

[Tom van Stiphout]

On Sat, 14 Nov 2009 10:31:15 +0300, "Alex Dybenko"
<ale...@PLEASE.cemi.NO.rssi.SPAM.ru> wrote:

Or on .NET, with a COM wrapper.

-Tom.
Microsoft Access MVP