Union Queries when Splitting Database

[jaypoppin]

Hi,

I am trying to split a fairly complicated database (~10 tables, with ~10 enforced relationships, etcetera). A bit part of the design is a union query that mediates between three tables, into a fourth.

I need to split the database so that I can distribute the front end around to other users. In order to split, I believe I have to delete the union query (because otherwise it "can't find the object" when I try to split).



This seems like it would be fine, because I can just go back and remake the union query after the split right? But how exactly does that work? I do it in the back end and the front end? Please help.

Thanks,

Jay

[pbaldy]

You shouldn't have to delete it, as long as you name the linked tables the same as the original tables (which is normally what I would expect). The union query would normally be in the front end, not the back.

[jaypoppin]

The union query is called "project assignments," it links two tables called "projects" and "people."


If I don't delete it beforehand, when I try to split the database, I get the following error:


"The Microsoft Jet Database engine could not find the object 'project assignments'. Make sure the object exists and that you spell its name and the path name correctly."


Is there a way to preserve the union query and split the database successfully, without running into this error?

[pbaldy]

Are you getting the error from the splitting wizard? I've never used it, I just do it manually. It shouldn't be trying to do anything with a query though.