??? ????????? ?? ????????? ?? ????? "???? ????? ???? exceeded? ????" ?????? ?????

?? ?? ?? ???? ?????????? ?? ???-?????????? ??????? ??? ?? ????????? ?? ?????????, ?????? ??? ????? ?????? ????? ?? ??? ???? ?? ???? ??:

?????? ?? ??? ?? ??? ??? ????????? ???? ?? ??? ?????? locks ?? ?????? ????? ????? locks ?? ?????? ?????? ?? ???? ?? ??? ???

???????????? ???, ????, ?? ????? ?? ????????? ?? ??????? ???? ?? ??? ????? ????? ??? ???? ???????, ??? ?? ????????? ?? ??? ??? ?? ??????? ???? ??? ?? ????? ???????? ??????? ?? ???? ???.. ?????, ????????? ???? ?? ?? ?? ????? ?? ??????????? ???? ???? ???.. ?????? ??????? ?? ???, ????????? ?? ??????? ???? ?? ???? ???? ??? ?? ???.. ???, ??? ??? ?????? ??????? ???? ?? ?? ?? ????????? ?? ???????????? ?? ???? ???.. ????????? ?? ??? ?? ???? ?? ???????????? ???? ?? ????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

?? ?????? ?? ?? ???? ?? ??? ?????? ????? ????? locks ??????? ??? ???? ?? ???, ????? ??? ?? ???? ?? ???? ????:.

???? 1: ????? ????? locks ?? ?????? ?????? ??? ?????? ???? ?? ??? MaxLocksPerFile ???? ?? ??? ????????? ????? ???

1. ????? ????,????????? ????-????? ????, ?? ???? ????????.
2. ??????:regedit?? ????-????? ????, ?? ???? ???OK.
3. ??????? ???? ?? ????? ????:
   • Microsoft Access 2000 ???, Microsoft Access 2002 ???, ?? Microsoft Office Access 2003 ??? 32-??? Windows ???????? ?????? ?? ?? ???, ????? ????????? ????? ?? ?????? ????? ?? ??? ????????? ?????? ?? ????? ????:
     HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0
     
     Microsoft Access 2000 ???, Microsoft Access 2002 ???, ?? Microsoft Office Access 2003 ??? ?? ?? 64-??? Windows ???????? ?????? ?? ?? ??? ???, ?? ????? ????????? ????? ?? ?????? ????? ?? ??? ????????? ?????? ?? ????? ????:
     HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0
   • Microsoft Office Access 2007 ??? ?? 32-??? Windows ???????? ?????? ?? ?? ??? ??, ????? ????????? ????? ?? ?????? ????? ?? ??? ????????? ?????? ?? ????? ????:
     HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access ??????????? Engine\Engines\ACE
     
     Microsoft Office Access 2007 ??? ?? ?? 64-??? Windows ???????? ?????? ?? ?? ??? ??, ????? ????????? ????? ?? ?????? ????? ?? ??? ????????? ?????? ?? ????? ????:
     HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access ??????????? Engine\Engines\ACE
4. ???? ??? ??? ????????? ?????? ??, ??? ????? ????MaxLocksPerFile.
5. ????? ????DWORD ??? ?? ?????? ????????? ????? ???, ????? ?????????.
6. Modify the value of the??? ????box as required, and then clickOK.

???:This method changes the Windows registry setting for all applications that use the Microsoft Jet database engine version 4.0.

Method 2: Use the SetOption method to temporarily change MaxLocksPerFile

???:The sample code in this article uses Microsoft Data Access Objects. For this code to run correctly, you must reference the Microsoft DAO 3.6 Object Library. ??? ???? ?? ???, ????? ??????????????? ????????????? Visual Basic ?????? ???, ?? ????????? ???? ?? ??Microsoft DAO 3.6 ???????? ???????????? ????? ????? ???

TheSetOptionmethod temporarily overrides the default number of locks per file. You set the default number of locks per file when you set theMaxLocksPerFile????????? ?????? You set the new value by using theSetOption?????? ??? The new value is valid until you close theDBEngine???????? ??? To use Method 2, follow these steps:

1. Microsoft Access ??????
2. Open a database, and then press Alt+F11 to launch the Visual Basic editor.
3. ????? ????Microsoft Visual Basic -Database Name>-[??????? ?? ???> (Code)]????? ?? ???, ????? ????Immediate Window?????????????? ??..
4. ???????? ?????, enter the following code.

   DAO.DBEngine.SetOption dbmaxlocksperfile,15000

5. Press the ENTER key to run the line of code.
   
   ???:This temporarily sets theMaxLocksPerFilevalue to 15,000.

To process large transactions, set theMaxLocksPerFilevalue to meet your requirement, and then run the transactions in the session.

Changes you make to theMaxLocksPerFilesetting by using theSetOptionmethod are available only for the current session.

TheMaxLocksPerFile?????? ???? ???? ?? ??? Microsoft Jet ???? locks ?? ?????? ?????? ?? ????????? ???? ??? ???????MaxLocksPerFile??? ?? 9,500 ??? ??? ??, ???? ??? ?? ??? ??? ?? ???? ????? NetWare ????? ?? ??? ?? ??? ??? ??????? ??????? ?? ????? ?????? ????? ??????? locks ?? 10,000 ??????? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

???? ??????? ?? ???, ????? Microsoft ???????? ?????? ?? ????: