O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

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

Using Forms to Control Editing and Save Records

In a single-user environment, one might be tempted to think that Access can handle tasks such as saving records in a form, especially when you consider that Access automatically saves the record you are adding or editing as soon as you move the insertion point to a different record, or close the current form. This all changes in a multiuser environment. Do you want two or more users to be able to access the same record simultaneously and save their changes? It depends on what you want to do. Table 21.3 explains the differences in the three RecordLocks property settings on a form.

Table 21.3. RecordLocks Property Settings
Property Value Comments
No Locks 0 This property often is referred to as ...

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