Composite index - can you mix data types?

[Fred Boer]

Hi!

I am trying to create a unique composite index. The index would use two
integer fields and two time fields. Access keeps complaining about creating
the index. I have stripped all but 4 records, so I *know* they aren't
identical. However, Access insists that I would have duplicate values.

I wonder: can you mix data types in a composite index? Is that the problem?


Thanks!
Fred

 

[Jeff Conrad]

Hi Fred,

I don't have any problems mixing data types for a composite index. Using your example and even one
with a Date/Time, Integer, Text, and Currency composite Index works just fine in my tests.

Do you have more than 32 indexes defined for that table? What happens if you delete all the records,
do a Compact/Repair, and then try to re-create the index? Same result?

 

[Fred Boer]

Hi Jeff!

Thanks for helping! Ok. That's good. I'm sure I don't have more than 2
indexes for the table. I will try your suggestion, but it will have to wait
til later tonight, or tomorrow. I have to go with my son to "meet the
creature" tonight!

Fred Boer

P.S. Gainfully employed as a "creature" myself! <g>

 

[Fred Boer]

Hi Jeff:

I tried it on a fresh copy of the database, and working with a fresh coffee,
I discovered it was something stupid: I had improperly constructed the
index. It is working now. And people wonder why I am so humble... <sigh>

Thanks.
Fred

 

[Jeff Conrad]

Hi Fred,

Good to hear that you have it working correctly now.
Always good to get a good night's rest and a fresh perspective.