Hide Tables and Application Code MSAccess 2003 Database

[pbala]

Hello,
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

[Stewart Ross]

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.

-Stewart

[NeoPa]

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.