Substruct Knowledge Base

The error may also occur when you run a Visual Basic for Applications procedure that uses the Synchronize method.

A member of the replica set contains too many changes for synchronization to be completed successfully. For example, if one of the replicas has increased in size by 100 megabytes (MB) because you have added a large number of new records, you may receive this error. The replica that contains too many changes may be the database from which you are attempting to synchronize, or it may also be another member of the replica set.

If you are using Microsoft Access 97, you can take advantage of a new feature that allows you to increase the MaxLocksPerFile setting for Microsoft Jet database engine 3.5 by editing the Windows Registry. The default value of this setting is 9500. However, changing this value is not recommended if one of the replicas is located on a Novell Netware server because the server’s maximum record locks per connection is 10000. In addition, changing this value will result in poor performance if one of the replicas is located on a server running Windows NT version 3.51 or earlier. If both replicas are located on servers running Microsoft Windows NT version 4.0 or Microsoft Windows 95, the maximum value of this setting is limited only by available resources. 

WARNING: Modifications made to the system registry are considered advanced usage of the Windows 95 or Windows NT operating systems. Extreme care should be taken when making modifications. Any invalid or incorrect entries may render the operating system unusable. 

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk. 

For information about how to edit the registry, view the Changing Keys And Values Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry. 

1. Quit Microsoft Access.
2. Click the Start button, and then click Run.
3. In the Open box, type regedit.
4. Locate the HKEY_LOCAL_MACHINE registry folder.
5. Expand the HKEY_LOCAL_MACHINE folder until you locate the folder SOFTWARE\Microsoft\Jet\3.5\Engines\Jet 3.5.
6. Double-click the Jet 3.5 folder to view its contents.
7. Select the MaxLocksPerFile entry; on the Edit menu, click Modify.
8. In the Edit DWORD Value dialog box, select Decimal and increase the number in the Value Data box.
9. Click OK to save the MaxLocksPerFile setting.
10. Quit the Registry Editor.
11. Start Microsoft Access and synchronize the replicas.