Hi, For some reason Microsoft's ODBC driver for MS Access reports an index for every foreign key that exists on a table. For example, consider the two tables. create table parent(id integer primary key) create table child (cid integer, id integer references parent(id)) For some reason, Access creates an index on child(id). This index is NOT visible from Access GUI but the ODBC driver reports it. Is there a way to hide this index from the ODBC client. Thanks.
Are you talking about indexes Access creates on linked SQL Server tables? If so, see the following whitepaper: Optimizing Microsoft Office Access Applications Linked to SQL Server http://msdn2.microsoft.com/en-us/library/bb188204.aspx If you're talking about ODBC-to-Jet, then you'll have a better response asking in the Access newsgroups. --Mary On Wed, 18 Jun 2008 08:46:45 -0400, Dennis Black wrote: >Hi, > >For some reason Microsoft's ODBC driver for MS Access reports an index >for every foreign key that exists on a table. > >For example, consider the two tables. > >create table parent(id integer primary key) > >create table child (cid integer, id integer references parent(id)) > > >For some reason, Access creates an index on child(id). This index is NOT >visible from Access GUI but the ODBC driver reports it. Is there a way >to hide this index from the ODBC client. > > >Thanks.
