By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,337 Members | 2,048 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,337 IT Pros & Developers. It's quick & easy.

Query links

P: 2
We have a problem importing tables and queries in a new DB. We lose the
links between tables when those are imported on the new DB.
Furthermore, we tried to fix the problem manually however, when we run
the queries we continue to lose the links, especially when the query is
a "make table" query.
Can someone help us?
Thank you in advance.

David
Sep 5 '06 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Have you run the Linked Table Manager to relink the tables?



We have a problem importing tables and queries in a new DB. We lose the
links between tables when those are imported on the new DB.
Furthermore, we tried to fix the problem manually however, when we run
the queries we continue to lose the links, especially when the query is
a "make table" query.
Can someone help us?
Thank you in advance.

David
Sep 5 '06 #2

P: 2
Have you run the Linked Table Manager to relink the tables?

Sorry.. probably I didn't express myself correctly. I'm not losing the external links but the query joins.
Sep 6 '06 #3

PEB
Expert 100+
P: 1,418
PEB
So maybe your columns in the tables have to be modified, or you do links with Crosstab queries and use a column from the crosstab!

There are the 2 possibilities!
Sep 6 '06 #4

PEB
Expert 100+
P: 1,418
PEB
Try to view in SQL each field with each field i connected and see the tables/queries that are source of information! If they have the respective columns you shouldn't have problems!

In fact an other reason can be the use of Subqueries as result of row! This can provoque a problem!
Sep 6 '06 #5

P: 1
We have the same issue. We had a database in Access 97 which we have "converted" to 2003. Since then a majority of our tables which have joins between fields in select queries "break". We can open the query, re-join the two fields and save query. Then later on when we open the query the join has disappeared. It is driving us mad and risking serious mis-reporting. Did you get a solution that worked. I read these posts but they didn't help me. Thanks.
Dec 11 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.