Workaround for Excel (Access) file share lockout number overflow (Error 3052)

Excel or Access may prompt that the number of file share locks overflows (Error 3052), that the major version is Office 2003, and that no other versions are encountered. The error prompts are as follows:

Microsoft JET Database Engine error ' 80040e21 ' File share lock number overflow. (Error 3052) Workaround: Modify the registry. (Enter regedit in the run to return.) Open the Run Window shortcut key win+r) code copy Code as follows [Hkey_local_machine/software/microsoft/jet/4.0/engines/jet 4.0] "MaxLocksPerFile" = DWORD:05F5E0FF will maxlocksperfile the default decimal value of 9500, I generally changed to 99999999 decimal. How to prompt for disk space or insufficient memory for table modification types or bulk operations in Access is also resolved from:http://www.111cn.net/office/excel/51028.htm

Workaround for Excel (Access) file share lockout number overflow (Error 3052)