'Subscript out of range' error won't appear when you compile, it is appear on run time. You just need to make sure that all array index is valid. If you can reproduce this error in your splitted database, have you test on your original (backup before it's splitted) using the same sequence/data and find out whether the error also appear on your original database?
Originally posted by Spanner
The error comes up as part of the split process, so I can't split the database.
I agree with Djoko.
This problem is with an array in your code. Typically, this will happen with arrays that are zero based (i.e elements are numbered 0,1,2,3,4 when there are 5 elements and you try to use the number 5 to access an element in the array). This can also happen when you dynamically resize the array.
I would look for where ever you are using arrays, and make sure the index you use to access the elements is consistant with how the size is declared or resized. Good Luck!