Solved

Access OPtions Advance - refesh and lock settings.

Posted on 2011-03-09
5
343 Views
Last Modified: 2012-05-11
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 Access Options Advance refesh and locking Access Options Advance refesh and locking
0
Comment
Question by:Louverril
5 Comments
 
LVL 5

Assisted Solution

by:mayankagarwal
mayankagarwal earned 75 total points
ID: 35081760
To be sure, set the default open mode option to: Shared

Office Button-->Access Options-->Advanced-->Advanced-->Default Open mode
rest is fine
0
 
LVL 6

Assisted Solution

by:YohanF
YohanF earned 50 total points
ID: 35081813
Its basically the locking strategy you want to use and the timeout in case of a deadlock.. Wikipedia for basic terminology...

In terms of record size, no there should not be a problem...
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 187 total points
ID: 35083471
There is no reason to change the defaullts unless you are sure they do not work for your application.

0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 188 total points
ID: 35085588
The settings you have for Record Locking (No Locks) will produce the best results.  You may need to up the values for  Number of Update Retries and/or Update Retry Interval ... if you have encountering a lot of Write Conflicts.

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
0
 

Author Comment

by:Louverril
ID: 35127484
Thanks for all your help.

I asked this due to the problem I identified, details  here: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26872052.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
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now