View Single Post
  #3 (permalink)  
Old November 13th, 2003, 08:53 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

The Man from UNCLE (insert secret agent music here ) answered the second part of your question. Here's the first part.

After you make your back-up (hint, hint) you click on TOOLS > DATABASE UTILITIES > MAKE MDE FILE. This will turn your MDB into an MDE. An MDE is (sort of) an executable-only version of your database. Access will not let you make an EXE file, but the MDE is close. The MDE will not let you edit or manipulate form designs, etc; and it strips the VBA code out of the database so it's not even visible to the user. Together with UNCLE's (not so secret) advice, this, and then creating custom toolbars, you can keep people out of your database's underwear (so to speak). :D

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote