"Subscript out of Range" error when Splitting Access '97 MDB

[Paul7905]

When I try to split my access '97 mdb I get an error message &quot;subscript out of range&quot; (I do not know what a subscript is; I am new to Access).&nbsp;&nbsp;<br><br>The splitter created the new database anyway,it has all the tables in it excepting the ones that I have linked to another access '97 mdb (there are 5 linked tables); ALL of the tables are still in the MDB I was splitting FROM however.<br><br>Thinking that the &quot;linked&quot; tables in my original MDB were the culprits (since they did not show up in the new backend mdb), I removed them from the original database and ran the splitter again; I still get the same subscript error message.&nbsp;&nbsp;Can anyone point me in the right direction to resolve this ?<br>thanks<br>Paul

 

[DougP]

I think maybe the error is coming from the linked tables.<br><br>Go into Help and type &quot;subcript out or range and it woill tell you what it means.<br>But...<br>It can't split a linked table because that would split a split if you know what I mean.<br>So just add you other linked tables back into your original .mdb and you will have all linked tables in it.<br><br>OK <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.