JOINS missing after splitting DB into front/back end 1

[as0125]

I've been experimenting with splitting my database into a front-end and a back-end. Here are the steps I followed:
1. create a blank db for the front-end (FE-DB).
2. while in FE-DB, imported all non-table objects from original DB (which I now consider the back-end db).
3. in FE-DB, linked to all tables in BE-DB.

Prior to removing all non-table objects from the BE-DB, I'm running my queries to make sure that everything works. But here are the problems:
1. all of the JOINS in the queries are missing.

2. running a query takes a long time and CPU shoots up to about 97%. why?

3. for a query based on another query are modified. for example:
SELECT Max(p.UpdateDate) AS MaxOfUpdateDate, p.Name AS Expr1
FROM Positives p
GROUP BY p.Name;
Access automatically added "AS Expr1" in the SELECT statement.

 

[PHV]

I suggest another stepping:
1. create a blank db for the front-end (FE-DB).
2. in FE-DB, linked to all tables in BE-DB
3. while in FE-DB, imported all non-table objects from original DB starting from elementary queries.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

BTW, why not using the database splitter wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[as0125]

ah-ha!!! that worked! why does the order make a difference as long as tables are linked anyway?

regarding the db splitter wizard: i didn't want to use it b/c i wanted to understand how to do it manually.

 

[PHV]

You imported queries on non existent tables.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244