Problem with Microsoft Access ODBC driver.

Hi,

For some reason Microsoft's ODBC driver for MS Access re****ts 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 re****ts it. Is there a way 
to hide this index from the ODBC client.

IM****TANT: I am talking about native Access tables - not linked tables 
from an external source.




Thanks.