ACCESS FEED: RE: RE: [MS_AccessPros] Too many indexes.

Senin, 02 September 2013

RE: RE: [MS_AccessPros] Too many indexes.

Hi John,

Thanks for the quick response.
I'm aware that the hidden indexes are created by Access to maintain referential integrity, but I didn't know which ones were duplicates of the indexes that I had created manually IYKWIM. I've written a little routine to list all the indexes on a particular table, so I can now see which ones are duplicated & delete the manually created ones.

Regards,
Andrew

--- In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

Andrew-

"Hidden" indexes are a result of defining Referential Integrity and should not be removed. Let's say you have an Orders and a Customers table with a Referential Integrity rule defined between CustomerID in Customers and CustomerID in Orders. If you've also defined a separate index on CustomerID in the Orders table via the Indexes window, that's a duplicate and can be removed. Also take a look at compound indexes - indexes on multiple fields. If you have separate indexes on each of the fields, you don't need the compound index.

Hope that helps...

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

-----Original Message-----

From: MS_Access_Professionals@yahoogroups.com [mailto: MS_Access_Professionals@yahoogroups.com ] On Behalf Of adwsys

Sent: Monday, September 02, 2013 1:35 PM

To: MS_Access_Professionals@yahoogroups.com

Subject: [MS_AccessPros] Too many indexes.

Hi All, I've run into the "Too many indexes" problem on a couple of tables in one of my Access 2003 applications. I know that there are several duplicate indexes in the tables, but I'm not sure which ones I can safely delete. The hidden ones don't show up in the Indexes dialog anyway & have to be deleted programmatically, so does anyone have a copy of Allen Brownes CleanUpIndexes utility handy, or anything similar.

Thanks, Andrew

------------------------------------

Yahoo! Groups Links