asked on

Access OPtions Advance - refesh and lock settings.

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

SOLUTION

mayankagarwal

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

YohanF

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Louverril

ASKER

Thanks for all your help.

I asked this due to the problem I identified, details here: https://www.experts-exchange.com/questions/26872052/Cannot-save-memo-field-when-more-than-1-user-and-356-chars.html that Jim Detman has taken to Microsoft.

I thought I might be missing something - at least I understand this section better now. I have always just used the settings above (with the shared mode as default) and had no problems until the issue with memo fields in the question on the link here.

Thanks again!
Lou