Indexing Tables created from the "Make-Table Query"

  • Thread starter Thread starter Mark
  • Start date Start date
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
 
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.
 
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
 
-----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-----
 
Back
Top