• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Securing Your Database > Security Considerations in a Project File

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 to open your project file, but won’t be able to open the design of any of the forms, reports, or modules. There’s no source code to examine, so a user won’t be able to view the code to figure out how it works or discover any techniques that you don’t want divulged. You can learn more about how to create an execute-only file in Chapter 31, “Distributing Your Application.”


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint