2003-Import of Queries with Relationships

[Dave]

We just shifted to Access 2003 at work.

I have a database that contains information that is updated each month with
another (source) Access file.

To update the fields in our database, I built (and used fine up till now) a
number of queries that copy the appropriate field contents and update the
fields in our database. This is done using a Unique_ID number common to
both.

I save the queries in a mock database, and import, then delete after use
each month (becuase it creates temp tables, and it cuts down on the clutter)

Now, when I import the query that contains a 1 to 1 relationship between
[NewTable].Unique_ID and [OldTable].Unique_ID, the relationship line in the
GUI seems to be lost each time. It used to import fine. I haven't tried
importing the query in SQL mode.

Is there a way to import this query while retaining the relationship?

Dave

[Jeff Boyce]

Dave

I'm not entirely clear -- are you creating an empty database and importing
queries to it because you are using "make table" queries ("because it
creates temp tables") and don't want the "bloat" in your regular database?

Your post mentioned updating fields -- why do you need temp tables to do
that? Does your import data change every time, so that there's nothing
common about the fields that you are updating (in which case, how do you
know which fields to update and how?!)?

Another approach might be to create a database and the tables to hold your
import data, then run your queries from your main database, using those
import tables as linked tables. Yet another approach might be to just use
queries to "massage" your data, on the way to updating.

Good luck

Jeff Boyce
<Access MVP>

[Pieter Linden]

Oh, major red herring. Relationships are stored in the database, not
in queries. I think MichKa has stuff on his website that lets you
"import" the relationships.. .

www.trigeminal.com