Indexes for imported and linked tables

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

Is there any way to set up indexes when importing or
linking to an odbc data base? I need to have queries run
faster.
 
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.
 
Back
Top