DataBase - Hiding Functions

Asked By Jim Franklin

13-Nov-09 01:58 PM

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

13-Nov-09 03:02 PM

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!)

14-Nov-09 02:31 AM

Hi,
you can also consider building library DLL on VB6

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

17-Nov-09 09:14 AM

Or on .NET, with a COM wrapper.

-Tom.
Microsoft Access MVP