Indexing Tables created from the "Make-Table Query"

M

Mark

How do I index a table that was created using the "Make-
Table Query"? I would like the index to be included
automatically when the table is created?

Thank you,
Mark
 
J

Jeff Boyce

Mark

If you use the automatic Make Table query, you don't get to pick indexed
fields. However, you can click on the Tables tab and open a "made" table in
design mode to subsequently add indexing.
 
M

Mark

Jeff -

Is there a way to index tables using VBA code?

Maybe I should ask this in the "Modules" subject area.

Thank you for your help.

Mark
 
M

MGFoster

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

Use the DDL command CREATE INDEX & run it as a regular Access query.
VBA/DAO example (all on one line):

currentdb.execute "CREATE INDEX Index_Name ON Table_Name (column_name)",
dbfailonerror

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

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

iQA/AwUBQO2MXoechKqOuFEgEQJGCwCbBajPyEbAn3lF9tKXAP1U1n4uKV4AoKdJ
ndatF424r5C2OEmz0wbAoI1j
=nwmZ
-----END PGP SIGNATURE-----
 
Top