Database Splitting Problem

[cdacey]

I am trying to split my database and the database spliter wizard seems to get about 90% through the processs and then give me a "Subscript out of range" message, when I click OK , it gives me "Invalid procedure call or arguement" message. It does create the separate database with the tables, but does not link them to the front end database, and leaves the fron end database with all original tables as it was.

Any thoughts ? I am competely stuck on this.


Thanks
Chris

 

[llkhoutx]

For mdb A holding all your tables, make a backup copy of mdb A, then create a blank BE mdb, then open it and import all your tables from mdb A, then delete all the tables in mdb A, then link all the tables from the BE mdb to mdb A.

File/Get External Data/Import - to import tables

file/Get ExternalData/Link Tables - to link tables