sort records

[Guest]

I have a simple Access data base for names ans addresses that I created in
2002 using MS Office 2000.
I recently upgraded to Office 2003 and Access opens the data base OK and I
can add new records to it no problem, but the new records always go to the
end and I cannot sort them.
The 'Sort' in Records menu is greyed out. In 'Options' Advanced the 'No
Locks' button is selected, but if I click a 'Sort/Filter' assistant tells me
that records are locked, but they are not.
Can anyone help please.

 

[Guest]

Build a query. Open the query in design view and in the SORT row of the grid
select Ascending for the fields you wish to sort on. Position the field that
will be the high order field as the left-most field being sorted if you are
sorting on more than one -- State, City, LastName, FirstName.

 

[Guest]

Thanks for the reply Karl, but when I try that and click 'apply filter'
assistant still comes up to say that records are locked. but they are not, as
the 'no locks' button is selected in Tools, Options, Advanced.