Jan 11, 2006 #1 K kaisersoze Well-known member Joined Aug 27, 2003 Messages 152 How to create index in MS ACCESS programatically? Please respond...
Jan 11, 2006 #2 Nerseus Danner Joined Oct 22, 2002 Messages 2,547 Location Arizona, USA User Rank *Expert* You run a query that looks like this: CREATE INDEX [IndexName] ON [TableName]([ColumnName]) There are probably some other forms, such as multiple columns if Access supports them. Check the MS Access help. -ner
You run a query that looks like this: CREATE INDEX [IndexName] ON [TableName]([ColumnName]) There are probably some other forms, such as multiple columns if Access supports them. Check the MS Access help. -ner
Jan 11, 2006 #3 Nerseus Danner Joined Oct 22, 2002 Messages 2,547 Location Arizona, USA User Rank *Expert* You run a query that looks like this: CREATE INDEX [IndexName] ON [TableName]([ColumnName]) There are probably some other forms, such as multiple columns if Access supports them. Check the MS Access help. -ner
You run a query that looks like this: CREATE INDEX [IndexName] ON [TableName]([ColumnName]) There are probably some other forms, such as multiple columns if Access supports them. Check the MS Access help. -ner