Question Locked

In Access 2003 can you create an index in a make table query?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have tables that update weekly and some that update daily from other tables. Certain databases have my linked tables so I can only update some of them but when I run my make table query it automatically overides the indexs I have saved in my master tables. In my make table queries can I include the option to create an index on a field to keep my index in the table.

2 replies

by larryd4

Logically if you are making a new table, you can't define the indexes for that table until its actually made. You may have to define the new indexes via VB or a macro after the fact.

This discussion is closed to new replies.