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

Chapter 20. Exploring Access Data Projec... > Securing Your Project as an .ade Fil...

Securing Your Project as an .ade File

When you distribute Access projects to users, the only security you can apply on the client side is compiling the project to an encoded .ade file. Like .mde files, projects stored in .ade format prevent users from making design changes to the front end and gaining access to your VBA source code. When you use the default integrated Windows authentication for the back-end SQL Server database, which is the recommended configuration for SQL Server, you can’t apply password protection to the project. Windows authentication prevents users who haven’t been assigned server logins and database permissions from opening the project’s connection to the server.

→ To learn how to use OSQL to add logins and database permissions to MSDE, see “Adding User Logins with the OSQL Utility,” p. 776.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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