Database split

[JOM]

I want to split my database, but am getting the following errors... subscript
out of range and invalid procedure call or argument do you know why thiss
happened?

Alsocould it be that database that am about to split has 2 tables that are
alread link to a different database but about four others are not....
I am using office 2003

 

[Larry Linson]

I want to split my database, but am getting the following
errors... subscript out of range and invalid procedure call
or argument do you know why this happened?

More than likely, you have a compilation error in your database that you
need to correct (before running the Database Splitter). Open any module, and
Compile (or Compile All Modules, depending on the version). This should find
the compilation error locations so you can fix the problems.

Alsocould it be that database that am about to split has 2
tables that are alread link to a different database but about
four others are not.... I am using office 2003.

It is often just as simple to make a copy of the database, delete the tables
from the "front end", and use File | Get External Data to link the tables in
the "back end". If all users will have retail Access, they could use the
Linked Table Manager to maintain those links; if not, or you prefer to
automate somewhat, you could include your own code to relink if the links
are broken (as often happens).

Larry Linson
Microsoft Access MVP