Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: File Lock Error (VBA)
Title: File Lock Error Language: VBA
Description: Occasionally, a file lock error exceeded message will come up when accessing records through DAO. To temporarily avoid this use the code line below. Views: 68
Author: Steve Moore Date Added: 2/8/2010
Copy Code   
1DAO.DBEngine.SetOption dbMaxLocksPerFile, 99000
Usage 
As above (the numeric value is editable)