retrieval order in ms access

[gangac]

in what order are records , whch have no unique key retrieved in ms access, assuming i do not have an order by in my 'select clause' . In oracle, there is no guarantee of the retrieval order if there is no 'order by' in the query.

thanks,
chandran

 

[Kiwiman]

Howzit

I believe Access acts in the same way. If you want a specifi order you should specify it.

 

[boblarson]

The records must be given a sort order (in your query) to retrieve them in a particular order. Otherwise there is no guaranteed order and the order can change without warning if no order by clause is supplied.

The OrderBy in the table only applies to the view that you get when you "open" the table. When you "open" a table for viewing, it is really just a query you are seeing.