How stop Append from sorting records?

[Sam]

I have an append query that does a left join on 2 tables. The query orders
the records according to the order in which they are stored in the left table
(the 2 tables are really links to a dbase db (left) and an external ACCESS db
(right)).

When I have the query append to an empty table (just has the fields defined,
Order By On Load = No, Order By = No, no primary key, all fields are text),
the records are appended in sorted order using the first field (which is not
the join field FYI).

How can I stop the sorting during the query append operation so that the
records are stored in the order the query displays - which is the order of
the records in the dbase file?

With Regards-
Sam

 

[Sam]

Thanks for your response-

Why is it important to you that the
records in the table be in some specific order?

This db is part of a data set that makes up an ESRI shape file. The db
records need to stay in the same order so that they remain in synch with the
other files.

 

[Gina Whipp]

Sam,

In Access the BEST way to control the order of the records is via a query.
You can set the Order By in the table Properties window. I've never done
that and then appended data but it should retain the order.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Sam]

Thanks Gina-