Importing query loses the table relationships

D

Doug F.

When I import a query (which has 2 tables linked) into a blank interim
database and then import from the interim database into a production database
the linkage is lost. It seems that during the import (into interim) the
tables must exist in that database else you lose the links at that point. I'm
using MSO2003. Thoughts?
Thanks.
 
6

'69 Camaro

Hi, Doug.
It seems that during the import (into interim) the
tables must exist in that database else you lose the links at that point.
Click to expand...

Correct. No tables, no relationship.
Thoughts?
Click to expand...

When importing the queries into the interim database, select the "Options"
button on the bottom right corner of the Import Objects dialog window.
Ensure that the "Relationships" check box is checked, and in the "Import
Tables" section, ensure that the "Definitions Only" check box is checked.
Select the tables listed in the relationship, and these empty tables will be
imported with the queries and relationships, too. The relationships will
remain intact when you import these queries and relationships into the
production database.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
D

Doug F.

Hi Gunny,
Thank you.

--
Doug F.


'69 Camaro said:
Hi, Doug.


Correct. No tables, no relationship.


When importing the queries into the interim database, select the "Options"
button on the bottom right corner of the Import Objects dialog window.
Ensure that the "Relationships" check box is checked, and in the "Import
Tables" section, ensure that the "Definitions Only" check box is checked.
Select the tables listed in the relationship, and these empty tables will be
imported with the queries and relationships, too. The relationships will
remain intact when you import these queries and relationships into the
production database.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
Click to expand...
 
Top