New table has some fields set to Indexed - Don't want

[Guest]

I have a problem with tables and the defaulted index value for a few of my
fields.

For example, I have another database where I perform a TransferDatabase and
transfer a Table into my current database. When that table is transferred
in, I always have three of the fields where its index has been set to Yes
(Duplicate OK).


The properties of the database I am transferring from doesn't have any index
- I just check that.

How can I cause this from happening????


Thank You,

Gary

 

[Guest]

Hi Gary,

Perhaps this will help?
http://www.access.qbuilt.com/html/gem_tips.html#AutoIndex


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[John Vinson]

I have a problem with tables and the defaulted index value for a few of my
fields.

For example, I have another database where I perform a TransferDatabase and
transfer a Table into my current database. When that table is transferred
in, I always have three of the fields where its index has been set to Yes
(Duplicate OK).


The properties of the database I am transferring from doesn't have any index
- I just check that.

How can I cause this from happening????

Open the database (actually any database) and select Tools... Options;
select the Tables/Queries tab; and blank out the thoroughly silly
AutoIndex On Create textbox.

By default, Access "helpfully" puts indexes on fields whose names
begin or end with certain characters. Of course, this might sometimes
be useful - but I'd prefer to define my own indexing scheme, thank you
very much!!

John W. Vinson[MVP]