O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required