(I've tried this Q in the ms forums without response. See how it goes
here.)
Using A2003 but I guess this is not version-specific...
If I want to implement row/record level locking on a split database where
do I need to set this option. Is it sufficient to set it in the frontend
database for record-level locking to apply to the backend tables. Or must
I also set it in the backend mdb database instead or as well (which is
never 'opened' in an Access sense.
To take this further, what about a situation where some backend tables are
being shared between different frontend applications. Let's say there are
two applications, one requires record level locking and the other doesn't
and both apps are set 'correctly' for their own operation.
How does it work then because there is only one ldb file per backend?
(I'm leaving this Q as mdb-specific because that is my immediate interest
but obviously it could be continued
further)
Enlightenment welcomed.
Peter