I am using Access 2003. I have a split data base with tables in a server. The system is sometimes annoyingly slow. I have googled the problem and implemented a lot of the recommendations, with small improvement. (With tables not split, system is fast). I have been told that the problem is Access.
According to my source, the criteria in a query does not restrict the number of records and fields exported from the server. Rather, the whole table is exported, then the query selects. So, as the tables get bigger, the whole system will be even slower. Supposedly, some other db programs don't do it this way.
Is this true? Hate to learn another db.
Thanks for any help or direction.