Can I specify an index in a make table query?

[Guest]

I'm dealing with an Access 2000 database in which many tables are frequently
updated through the use of make table queries... these tables then need to be
manually indexed... (don't ask why... it wasn't my idea.) ...the process
will change soon enough, but in the very short term, I need to find a more
efficient way of doing things.

Is there a way to specify that a particular column will be indexed
(non-unique) when I run a Make Table query?

Thanks,

 

[MGFoster]

I'm dealing with an Access 2000 database in which many tables are frequently
updated through the use of make table queries... these tables then need to be
manually indexed... (don't ask why... it wasn't my idea.) ...the process
will change soon enough, but in the very short term, I need to find a more
efficient way of doing things.

Is there a way to specify that a particular column will be indexed
(non-unique) when I run a Make Table query?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not during the MakeTable run. You'll have to create the index
afterwards. Run something like the following after the make table query
finishes.

CREATE INDEX idx_ColumnName ON table_name (column_name)

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQjIH0YechKqOuFEgEQKNaACfV2ajXOrzGix6JP+MMarYrn/QPBQAmQHY
BH+uXxzA+hItsrsqwoUq8yck
=BKT3
-----END PGP SIGNATURE-----