Please could someone recommend settings for the Access Option Advance settings relating to refresh and locks in a multi-user environment with each user having a front end on their local PC and the back end in a central folder on the LAN- PLEASE SEE ATTACHED SNIP for the values I mean.
Does anyone have something with really explains in detail the difference they make - I am wondering is record size is an issue.
Many thanks,
Lou
I highly recommend you read the following KB's on record locking, as the subject is very confusing:
Jet 4.0 Row-Level Locking Is **Not** Available with DAO 3.60
http://support.microsoft.com/kb/306435
Page-Level Locking vs. Record-Level Locking
http://msdn.microsoft.com/en-us/library/aa189633(office.10).aspx
Record-Level Locking Does Not Appear to Work
http://support.microsoft.com/kb/225926
Handling Locking Conflicts
http://msdn.microsoft.com/en-us/library/aa165294%28office.10%29.aspx
mx