A database can be encrypted using the standard Access menus or by writing a VBA subroutine.
More articles by Alison Balter
Don't get locked out! Have you ever had trouble knowing what is and isn't locked when working with a Microsoft Access program? VBA offers several alternative locking strategies for the developer, ranging from locking the entire database to locking one record at a time. In addition, VBA lets you control how long data will be locked. This article shows you how.
Many developers misunderstand key aspects of the Access Runtime Engine and the Microsoft Office Developer. Microsoft Access can be used as a development tool. Not only does the Access Runtime Engine make it possible to distribute your applications to people who don't have Access, but it also lets you do a lot more.