Indexes & Make Table Queries

[davisto01]

I would like to create a table using a make table query and preserve/copy the index of the original table (the one the query uses to form the new table).

Is this possible or am I asking Access 97 for too much?

Thanks

TD

 

[PaulF]

Well, why not just copy the existing table to a new table using DoCmd.CopyObject, then you can delete all the records in this new table, and then use an Append Query instead of a Make Table Query....

Probably easier to accomplish

PaulF

 

[davisto01]

That's actually pretty exactly what I'm doing now except I'm using a link table instead of copying, then using the Append Query.

My boss is convinced however that indexing would eliminate the need to delete first. Since I'm deleting hundreds of thousands of rows this would save a lot of time.

I appreciate the input.

TD
: -)