I work with an access db with up of 90000 records. Just now I have problem with
1. I use this db on network with "back_end & front_end" option, and connection
to db takes about 10 minutes on lan network with 10Mbps
2. The search on memo field takes up of 15 minutes. I do the search by "like
expression". For example: select * from news where news.text like "*report*"
Is there any way to speed up the access db. I usually do "compact and repair" on
Thanks a lot