Security Considerations in a Project File
When you open an Access project file (.adp), Access does not reference a workgroup file at all. Consequently, you cannot individually secure the forms, reports, macros, and modules in your project file. Remember that tables and queries are stored in an SQL Server database, so SQL Server security applies to those objects.
You can, however, take some steps to protect your project file. First, you can convert your project file to an execute-only file (.ade). An execute-only file is a special version of your project file that contains no source code. Access compiles your project before creating the file, saves the information that Visual Basic needs to run, and then removes all your code. A user might be able ...
Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
