Splitting Database

[jbrickey]

I have a database the I have attempted to split both through the wizard and
manually. After the split, a few of the queries, not all, no longer run
correctly. The queries themselves have lost the "join" relationships. Or
the fields are no longer in correct. This, of course, affects a lot of areas
in the database. Has anyone experienced this and if so, how do you fix the
problem.

 

[Arvin Meyer [MVP]]

Relationships are defined in the tables (back-end) database. I've never used
the wizard because I've been doing it since long before there was one, and
it is so easy to do manually. Basically, make 2 copies of the database.
Delete the tables from 1 and everything else from the other. Then link them.
I've never lost a join this way.

You may not see any relationships when looking at the front-end, but they
are still there and regardless of whether they are defined or not, joins in
saved queries should never be lost.

If after manually splitting as outlined above, you still have a problem,
report back with complete details of Access versions and Service Pack
levels.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"(e-mail address removed)"