Re: Make column indexed

try here to, you'll probably need to find the right version for yourself:

http://msdn2.microsoft.com/en-us/office/aa905400.aspx

--
Got a big event coming up? Let us
help coordinate your event. For more
visit www.kissemgoodbye.com
"Brian Hollister" <bhollisterATfuturaintlDOTcom> wrote in message
news:464da4ac@xxxxxxxxxxxxxxxxxxxxxxxxx
Check the VBA help files. They should be located with the other help files
in your installed directory.

--
Got a big event coming up? Let us
help coordinate your event. For more
visit www.kissemgoodbye.com
"MikeR" <nf4lNoSpam@xxxxxxxxx> wrote in message
news:464d061a@xxxxxxxxxxxxxxxxxxxxxxxxx
Using ADOX I'm able to add an AutoIncrement column to an MS Access
table.
I'd like to
make it indexed as well. Tricks and tips? Any place to see the constants
like
AutoIncrement?
with col do
begin
ParentCatalog := cat;
Name := fName;
Type_ := adInteger;
Properties['AutoIncrement'].Value := true;
//Properties['indexed'].Value := true; <==============
table.Columns.Append(col, Unassigned, Unassigned);
end;
Thanks, Mike




.