That you disagree with somebody does not make that person wrong. Roger has
provided a wide range of assistance in this forum, and has made samples
available on his web site. Based on his track record I would be inclined to
follow his advice. If you are trying to convert people to the idea of using
clustered indexes, a very basic discussion of what they are would be most
helpful. I have taken your suggestion to look at Google groups. There is
indeed a lot of discussion, but I have not yet found how I would create a
clustered index if I wanted to. My databases with a few thousand records
seem to work just fine. Why would I want to put extra effort into something
that already works well? I know you have posted code that includes MAKE
TABLE or some such, but the utility of such code is not clear. The other
thing I noted in Google groups is that most of the discussion of clustered
indexes seems to be in discussions about SQL server.

wrote in message
oups.com...

Roger Carlson wrote:
Autonumber fields make excellent Primary Keys.

You've misunderstood what PRIMARY KEY means. An unique integer which
has no meaning in respect fo the entities being modelled makes a lousy
PRIMARY KEY. Google for "clustered index" in the Access groups.

An autonumber is a convenient uniqueifier but unquieness for its own
sake make not be such a good thing.