Re: Make column indexed

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


.

Relevant Pages

  • Re: VBA Help file(s) location
    ... the setup to install for local use, I searched all AddOns etc. on ... Christian Gosch ... >> Can anyone tell me where the VBA help files for Access are ...
    (microsoft.public.access.setupconfig)
  • Unable To Display Help error in Access 2007
    ... When I hit F1 for context-sensitive help within the Visual Basic editor, I get the error: "Unable to display help." ... Is there a place that all the VBA help files are listed, along with their appropriate paths? ...
    (microsoft.public.access.setupconfig)
  • Access 2000 Help
    ... Some of the VBA Help files in Access don't seem to be available (e.g., ... loaded to install all the Access Help files from the Office install. ... didn't work (nothing available on FindFirst etc). ...
    (microsoft.public.access.setupconfig)
  • VBA Help file not displayed properly
    ... problem with VBA help files. ... and this person solved the issue in 2003 by using a CD install instead ... Or any other advice would also be greatly ...
    (microsoft.public.office.setup)