Is there a way to Index an Access database so that several search quearies can be done without taxing the main database with every search. Such as an alphabetical listing of names that then pull up all records under that name?
Thanks!