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

Chapter 19. Linking Jet Applications to ... > Password-Protecting Jet Applications

Password-Protecting Jet Applications

All production database applications should have at least some level of security applied. The minimum level of security is password-protecting the front end. The problem with password protection is that users can open any Access object—except password-protected VBA code—in Design view and make changes to the front end. The only method of preventing unauthorized design changes to a password-protected .mdb file is to distribute a runtime version of your application, which requires the Microsoft Office Developer Edition (MOD). Runtime Access prevents users from opening any object in Design view.

Caution

Don't password-protect back-end .mdbs whose data you intend to replicate. Jet replication fails with password-protected databases. SQL Server back ends use publish/ subscribe replication, which relies on Windows 2000/NT or SQL Server security.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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