Macro

  • Thread starter Access Front End
  • Start date
A

Access Front End

Hi Anyone!

Can I hide all the macro in the database or lock it some how so no one can
modify it. Thanks

Ngan
 
G

Guest

hi,
you can make a MDE file.
Tools>Database utilities>make MDE file
Read up on MDE files in help and understand the full
ramifications of your actions. the process is non
reversable. MAKE A COPY OF YOUR DB FOR BACKUP!!!!
 
6

'69 Camaro

Hi.
Can I hide all the macro in the database
Click to expand...

Yes. But it's only hidden to those who don't have the "Show Hidden objects"
check box marked in the Options dialog window.

To hide each of the macros, right click on the name of the macro in the
database window and select "Properties" in the pop-up dialog window. In the
bottom left of the window, mark the "Hidden" check box in the "Attributes:"
section. Select the "OK" button to save your change. Repeat these steps
with every macro.
or lock it some how so no one can
modify it.
Click to expand...

The only way to lock a macro is to implement user-level security and then
remove users' permissions to modify each of the macros in the database. A
better way is to convert the macros to VBA code, delete the macros, then
create an MDE database file out of the MDB. The source code will be removed
from the file and the macros won't be available any longer for anyone to
fiddle with, either. Make sure that you save the MDB file for future
modifications, though, because most modifications that you might want to make
are not possible in an MDE database file.

In case you decide that you want to keep the macros -- instead of converting
them to VBA code -- and just create an MDE database file from your MDB file
without implementing user-level security, be aware that the macros can still
be opened in Design View, so anyone can modify or delete them. The same is
not true with VBA code modules.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.
 
Top