On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
Course Of The Month
6 days, 16 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Access OPtions Advance - refesh and lock settings.
Posted on 2011-03-09
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5 Comments
To be sure, set the default open mode option to: Shared
Office Button-->Access Options-->Advanced-->Advan
rest is fine
Office Button-->Access Options-->Advanced-->Advan
rest is fine
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...
In terms of record size, no there should not be a problem...
There is no reason to change the defaullts unless you are sure they do not work for your application.
Active 1 day ago
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
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
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
- The Email Laundry
- Email Servers
- Cybersecurity
- Email Protocols
- Network Security
- Security, *Phishing
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Suggested Courses
Course of the Month6 days, 16 hours left to enroll
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.