Errors: E231 Buffer length exceeded

Ouch. Time to increase buffer size!

Note: You may need an IT person to access the Registry.

To change the MaxLocksPerFile Registry setting:

1. Go to START, the RUN, type REGEDIT, click OK. Registry editor should open.

2. Open Hkey_Local_Machine\software\Microsoft\Jet\4.0 folder.

3. Double-click the MaxLocksPerFile entry on the right. An edit dialog box should open.

4. Click the Decimal radio button. Default is 9500 (in decimal)

5. This step is trial and error, start with a value of 50,000 then reimport. If you get the error again go back in and up the value. We had to take it to 1,000,000.

Hope this helps!