when splitting tables, wizard says "subscript out of range"

[Guest]

While reviewing my table structure, the Wizard suggested I split off certain
information into a separate table. After doing that, I tried to procede to
Next and got the "subscript out of range" message.

Thanks

 

[Allen Browne]

Here's Microsoft's page on what to do when the wizards don't work:
http://support.microsoft.com/?id=303769

 

[George Nicholson]

In addition to Allen's suggestion, try Compacting the mdb & re-running the
wizard. "Subscript out of Range" issues *could* be the result of a lot of
changed/deleted fields (or other things) taking up space that compacting
might cure. Sort of a long shot, but won't hurt to try.

HTH,