If neither creating record sizes that are larger than half a page nor using optimistic locking wherever possible is an acceptable approach for your application, there are other options you may want to consider. You could move your application to a client/server environment using a server that supports record locking or you could implement a custom locking scheme.
See Also For more information about client/server applications, see Chapter 9, “Developing Client/Server Applications.” For more information about custom locking schemes, see the following section, “Implementing a Custom Locking Scheme.”