Solved

macros in mde file

Posted on 2002-04-01
2
340 Views
Last Modified: 2013-12-05
I have a mdb file, I made a mde file from it to prevent showing the code.
but the mde file contains some macros. how can I prevent users to show the design of these macros in the mde file.
0
Comment
Question by:fadiwilliam
2 Comments
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 6910171
In general it is a VERY bad idea to use Macros FOR ANY PURPOSE in a real Access application.  This is so for several reasons (in fact, Microsoft has indicated that they are only supporting the macro capability in Access 2000+ for backward compatability, and MS STRONGLT advises against the conscious use of macros in applications developed with Access2000 and later versions)

1) Macros cannot be debugged - there is no way to interupt the steps of a macro to evaluate what is happeing at each step.

2) as you have discovered, since macros ARE NOT code, they are not affected by the process of generating an MDE, so the macros are fully exposed in the resulting MDE file.

3)Almost without exception, a macro can be replaced by the equivalent VBA code, with generally much more flexibility and control.
0
 
LVL 1

Accepted Solution

by:
jschrisman earned 10 total points
ID: 6910595
For each macro name in the list of macros, right click on the macro name and choose properties. Then set the Hidden property.

On the tools menu, choose Startup. Uncheck display database window and anything else you want to change.

This will hise the macros from the average user. However, anyone proficient in Access will be able to easily get around this.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now