Thanks Mike, I had actually already done that, but this:
DROP INDEX DocID
or
DROP INDEX T_Docs.DocID
didn't seem to work. I just couldn't figure out the correct syntax. So I
thought that perhaps Access actually gave the indexes some kind of internal
name, like DocIDIdx or something.
I eventually got the syntax though, I figured it out. This worked:
DROP INDEX DocID ON T_Docs
Thanks for your help!
Avi
At 12:57 PM 7/24/00 -0400, you wrote:
>If open the table in design mode at the top there is a link to the indexes
>for that table. You should find the names there.
>
>I hope this helps
>Mike
>
>
> >>> [EMAIL PROTECTED] 07/24/00 12:20PM >>>
>Does anyone know how Access 97 names its indexes? I am trying to DROP a
>column, but I get an error because there is an index on the column. So I
>would like to DROP the index, but I cannot figure out the actual name of
>the index. I can't figure out how Access names it indexes. If anyone knows
>this, I'd appreciate the heads up.
>
>Thanks,
>Avi
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
