Auto Index

[vvrt]

If a Table includes a foreign keys with the field name ending with "ID" the field will be indexed weather you want it or not.
You can deleat these redundant indexes by clicking the indexes button for a table in desing view.
To stop this from happing again click Tools , options , Tables/Queries Tab there is a box labeled "AutoIndex on Import/Create, clear this box

this may speed up you database It did with mine

Regards

v

 

[jsteph]

OR...
In Tools|Options...Table/Queries tab, you can delete the default AutoIndexstrings:
ID;key;code;num
...and put either nothing or whatever you choose in there.
--Jim

 

[jsteph]

sorry vvrt,
I didn't see that you had already put that at the end of your post...
--Jim