I’m searching a small table (150 records of 10 fields) from a form using the “Record Search” dialog and the search seems really slow. My search terms could be in one of two fields, so I am having to use the the “all fields” option instead of “single field”. A query finds all records meeting the criteria in a heartbeat, but I have to first modify the query’s search criteria which is kind of cumbersome, and once in a while there’s something in the record I want to change, which you can’t do with query results.
Any tips or ideas?
P.S. I have a dual-boot set up with Ubuntu 11.10 and WinXP on an oldish IBM laptop. I have my database in a DropBox folder. I have Open Office installed on the WinXP partition and when I search the database from there, it’s pretty quick. Ubuntu 11.10 installs Libre Office as default, so I’m using that on the Ubuntu partition and that’s where I’m having the problem.