471,092 Members | 1,076 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

Hide Tables and Application Code MSAccess 2003 Database

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
2 3293
Stewart Ross
2,545 Expert Mod 2GB
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
32,347 Expert Mod 16PB
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.

Similar topics

3 posts views Thread by Michael Gill | last post: by
7 posts views Thread by cefrancke | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.