MS-ACCES bad insert

I have problems when inserting data from one table to another in MS ACCES.
Some lines ar not in the same order than the table from which they come from
Even though I put an 'order by' in the sql request before inserting data, sometimes a bloc of lines gets inserted in the wrong order.
Has anybody seen ths kind of probleme before ?

The bad thing about this, is that it seems to happen randomly...
somtimes it works somtimes it doesn't !
Altough this is a microsoft product, I would like to know how to solve this ...

Thanks

Miles

Ordering a query result before inserting data accomplishes nothing. ORDER BY does not affect the actual data in the table, but simply the order in which you receive the results out of the table.

The thing you have to remember is that relational database systems by definition don't guarantee ordering of the data in a table. The only ordering you can guarantee is the ordering you specify upon performing a query. So, whatever part of your application requires ordering should access a Query (which specifies your ordering) instead of just connecting to a regular table.

Thanks for the reply,
I knew that relational database systems didn't garantee ordering but I was just hoping that MS ACCES circumvented this.

I cannot put an order by in the query for I have no key in the final table... Too bad

Anyway thanks for the post

Miles