Indexes for imported and linked tables

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.
 
G

GVaught

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Index into a Table 1
Linking text to photos 0
Table Security in Access 2013 1
Creating a Chart on form from selected data in query. 0
Converting URLs in comments to Markdown-formatted links 2
Embed the same Excel multiple times 0
Linking data in MS Word into Excel 5
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0

Top