Database Splitter

[Les]

When I run the Database Splitter I get the error message "The search key was
not found in any record". I'm not sure what this means or how to fix. Any
suggestions?

 

[Accessguru]

I would just split it manually then.

http://support.microsoft.com/default.aspx/kb/304932

 

[Arvin Meyer [MVP]]

When I run the Database Splitter I get the error message "The search key
was
not found in any record". I'm not sure what this means or how to fix.
Any
suggestions?

You may need to install a later Jet Service Pack:

http://support.microsoft.com/kb/301474

The absolute easiest way to split a database is to make 2 copies. Delete all
the tables from 1 of them, and everything but the tables from the other.
Compact them both, then link the tables to the code database:

File >>> Get External Data >>> Link

Select All >>> OK

 

[Larry Linson]

The absolute easiest way to split a database is
to make 2 copies. Delete all the tables from 1
of them, and everything but the tables from the
other.

My view is, substitute "tables and relationships" for "tables" in Arvin's
reply above. The relationships, to have any effect, must exits in the same
database with the tables involved in the relationships.

Larry Linson
Microsoft Office Access MVP

 

[Douglas J. Steele]

My view is, substitute "tables and relationships" for "tables" in Arvin's
reply above. The relationships, to have any effect, must exits in the
same database with the tables involved in the relationships.

<picky>
Arvin did say to work with two copies of the database.

Deleting the tables from the one copy will also delete the relationships
from that copy.

Deleting everything but the tables in the second copy will leave the
relationships as well (unless they explicitly delete the relationships,
which, I suppose, Arvin didn't say not to)
</picky>

 

[Arvin Meyer [MVP]]

Deleting everything but the tables in the second copy will leave the
relationships as well (unless they explicitly delete the relationships,
which, I suppose, Arvin didn't say not to)

Don't delete the relationships in the second copy <lol>

 

[Larry Linson]

It never hurts to be "abundantly clear". (You may have noticed, Doug, that I
_do_ wear both a belt and suspenders.)

Larry

 

[Les]

I only get the error when using the splitter. I tried the repair process you
suggested but still get the error. I have opted to do the manual split as
the others suggested and that worked.
Thanks for your help.
Les