28-Jul-2006, 08:02 AM
| || |
| || || || || |
| || |
Re: Northwind Mystery
"Tom Ellison" wrote in message
> 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.
Not just ID, Access automatically indexes fields ending in:
ID; key; code; num
unless you disable this in Options.
Arvin Meyer, MCP, MVP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9472
Free Access downloads