i have many tables and when i open them in msaccess they are sorted ascending though opening them in delphi they arent.(note theres no index as such )
i just wish to sort the table ascending via the field named combobox1.text +' Title'.
(the active table in delphi is set via a combobox)
i looked at adotab1e.sort := combobox1.text +' Title');
but got various errors using it..though looking at the help file it should work..