By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Hide Tables and Application Code MSAccess 2003 Database

P: 37
I am using MSAccess 2003 Database which contains tables and some forms. I want to hide the tables and form code from some users.Only developer will going to view this. How did I hide the tables and code from users while at Run time. Now user will view my code and open the data tables freely. How can I avoid this?

Please help me
Feb 17 '09 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 2,545
Hi. Consider saving the working copy of your database as an MDE file. If you do go this route it is important to keep a reference copy of the current MDB file for future development and for back-up purposes.

About MDE files (MDB)

If your database contains Microsoft Visual Basic for Applications (VBA) code, saving your Microsoft Access database as an MDE file compiles all modules, removes all editable source code, and compacts the destination database. Your Visual Basic code will continue to run, but it cannot be viewed or edited. Your database will continue to function as it did you can still update data and run reports.

Saving your Access database as an MDE file does not prevent changes to the database design. However, you will notice the following:

* The user interface for modifying or creating forms, reports, or modules will be disabled.
* The VBA References dialog box will not allow adding, deleting, or changing references to object libraries or databases.
* The source code will not be available.
* The importing and exporting commands will be disabled for forms, reports, or modules. However, tables, queries, data access pages, and macros can be imported from or exported to non-MDE databases.
Feb 17 '09 #2

Expert Mod 15k+
P: 31,411
An alternative approach :
  1. In the VBA Editor window (Alt-F11 from Access) select the Project Properties (Tools / {ProjectName} Properties - Alt-T,E).
  2. Select the Protection tab.
  3. Select Lock project for viewing.
  4. Enter your password twice.
  5. OK.
Feb 17 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.