Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > access > answers

Query links

Newbie
  
Join Date: Sep 2006
Posts: 2
#1: Sep 5 '06
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

msquared's Avatar
Administrator
  
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,886
#2: Sep 5 '06

re: Query links

Have you run the Linked Table Manager to relink the tables?



Quote:

Originally Posted by Yomy1979

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
Newbie
  
Join Date: Sep 2006
Posts: 2
#3: Sep 6 '06

re: Query links

Quote:

Originally Posted by mmccarthy

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.
PEB's Avatar
PEB PEB is offline
Expert
  
Join Date: Aug 2006
Location: Bulgaria
Posts: 1,380
#4: Sep 6 '06

re: Query links

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!
PEB's Avatar
PEB PEB is offline
Expert
  
Join Date: Aug 2006
Location: Bulgaria
Posts: 1,380
#5: Sep 6 '06

re: Query links

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!
Newbie
  
Join Date: Dec 2006
Location: Buckinghamshire
Posts: 1
#6: Dec 11 '06

re: Query links

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.
Reply

« previous question | next question »

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,501 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved