situation: A guy has 2 databases. I split db1 per request. After I split it successfully and linked the back end to all 4 computers, THEN he tells me he has a querry in db2 that no linger works. The querry in db2 used data in db1. How do I link it or fix it. I tried linking db2 to the back end of db1 (not really having a clue) and it didn't work. thanks
http://www.accessforums.net/images/misc/progress.gif

You can not link a query to fe from be, rather you just create the same query in the fe and run.

but the query in db2 worked before I split db1. Splitting the db1 was all I did. How did this make the query in db2 stop working? And are you saying scrap it and redo it? Just seems like I should be able to link it somewhere since splitting the db was all that I did

the query will work exactly the same before it was working in db 2, just examine and check for the fields and the tables used in that query, re-link the tables from the source database if necessary to get it work.

Hi,

Basically, what Khalid is trying to point out to you is that on splitting your databases, the table that the query was originally getting it's information from is now not in the database in which the query resides! In order for the query to work, it needs the table to exist in the split database that the query resides in.

So what you need to do is create a link to that table from the split database to where the table resides, once you have done that, your query will work again as required.

If your query is based on multiply tables then all those tables need to be linked to from the split database where your query resides to the database where the tables reside.

If your query is based on other querys and tables then again tables that are used by those queries need to be linked to.

Hope this helps you.

John