Wednesday, November 28, 2007

Unnecessary Indexes

One of the most common table traps in Access is the unnecessary index trap. I have mentioned this on my website and in a couple of other magazines a number of times.

http://www.vb123.com.au/Toolbox/05_docs/accessdevelopertraps.htm


FMS have also come up with a new page on the topic
http://www.fmsinc.com/free/NewTips/Access/AutoIndex/index.asp

So open your database backend and start looking for those dups and then turn off the automatic feature in your Options.

No comments: