Sikh Philosophy Network - View Single Post

#8 (**permalink**) 28-Jul-2006, 08:02 AM

"Tom Ellison" wrote in message
news:OWIn5LWdGHA.3352@TK2MSFTNGP03.phx.gbl...
> Dear Albert:
>
> Now, that's some good stuff! Thanks!
>
> I certainly didn't know Access would create indexes based on column names.
> That seems weird indeed. But it probably explains why these indexes are
> there. Whoever built Northwind may not have known there were there.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9472-northwind-mystery.html
>
> I'll be sure none of my numeric columns ends in ID. That's for sure. I
> like to control the design of my tables, not have it taken from me.

Hi Tom,

Not just ID, Access automatically indexes fields ending in:

ID; key; code; num

unless you disable this in Options.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9472
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access