Re: Exceeds maximum index number

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: RSGinCA (rsginca_at_aol.com.NO.Spam)
Date: 03/03/04 

Date: 03 Mar 2004 04:45:28 GMT

Ok...

Here's a note about Access 97:
"In Microsoft Access 95 and Access 97, a single table cannot have more than 32
indexes and direct relationships combined."

See:
http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaracces
sdev/html/odc_access97conversionissues.asp

This specifically refers to Access 95 and 97 BUT I think it was written in 1997
and was specifically talking about conversion from an EARLIER version of
Access. So the fact that it was specifically referring to 95 and 97 doesn't
mean that it doesn't apply to Access 2003.

I do know that the specs for Access 2003 do say that 32 indexes are allowed in
a table and that it makes no mention of relationships, but who knows... If I
had the time I'd try it out to see if a lot of relationships affect it. From
your experience I'd be almost willing to bet it does.

Another thing: I was looking around, and I think I saw someplace that if you
specify "enforce referential integrity" for a relationship that a index will be
build for BOTH sides of a relationship. Do you have that specified for your
relationships? (Go to the relationship window... right click on the
relationship line... click on 'edit relationship'. There's a checkbox for
"Enforse Referential Integrity"... Is that checked?)

Rick

>Subject: Re: Exceeds maximum index number
>From: "=?Utf-8?B?VG9kZA==?=" anonymous@discussions.microsoft.com
>Date: 3/2/2004 8:01 PM Pacific Standard Time
>Message-id: <188D4444-D3DE-4E24-B658-8A68E3C0AD52@microsoft.com>
>
>Access 2003

Relevant Pages

  • Re: Importing Data into Access from Word / txt files
    ... specify the column type for the checkbox as YesNo ... The field label is there, ... I'm making the conversion through Access code. ...
    (microsoft.public.word.conversions)
  • Converting Pipe Delimited Text File To Tab Delimited Text file
    ... All fields must be trimmed of extra spaces (I assume either the TRIM, LTRIM ... OR RTRIM commands can be used for this. ... A form to specify the input and ... output and a button to run the conversion is required for this task. ...
    (microsoft.public.access.modulesdaovba)
  • Re: How should I specify size?
    ... >> Hello, when using cin.getlinewith a char array, how should I specify ... > simply use whatever type the prototype specifies. ... scope, the conversion is automatic. ... The functional-like cast just ...
    (comp.lang.cpp)
  • Re: use a quote for integer data type in SQL statement?
    ... If you compare a string value to an integer value then the string value will ... isn't valid for numeric conversion. ... Specify literal values correctly: ...
    (microsoft.public.sqlserver.programming)
  • Re: No Nulls allowed for FK in Access?
    ... Try using the Join Type button. ... > When I specify "Enforce Referential Integrity" on a table relationship in ... > Access 2003 it fails saying that the child table FK cannot be NULL. ... > Is there any way to enforce referential integrity in MS Access and still ...
    (microsoft.public.access.gettingstarted)