You may be able to open the linked table in table design view and create an
index within Access. This may help with your problem. Also note that slow
execution can be due to your network and have nothing to do with Access and
your linked tables. You can create indexes against any imported table. Also,
having said this. Be aware that too many indexes on an Access table can slow
it down more than if you didn't create the index.