🚀 go-pugleaf

Yep, you are right, I dropped the index field size to 125 and the index was
then visible, dont understand the limitation, but I suppose if I thought
like MS then I wouldnt be here... Thanks

"Jerry Bloomfield (TeamB)" <JersWork@wwa.com> wrote in message
news:hjdb8t87c7afj3ht4grob3l6omqvgepi1i@4ax.com...
> On Wed, 7 Feb 2001 19:05:07 -0500, "PRG" <dork@dork.net> wrote:
>
> >I am using MS-Access and have defined a field with a size of 150. When
> >attempting to select the index name for this field it is unavailable in a
> >TTable component. If I reduce the size to say... 50, it is then visible.
> >Would this be a setting somewhere that is causing this, or a
compatability
> >issue. FYI Paradox table with same definition works fine.
>
> I am not sure about the MS-Access limits (and they probably vary by Access
> version),  but it sounds like you have exceeded the maximum length of an
> index.  I encountered this problem on an SQL Server a while back when I
> tried to add a 255 byte text field to a key on a table...
>
> Each database format/engine has its own limitations on what are
acceptable,
> and it sounds like you found one limitation where MS-Access is less
> flexible than Paradox...
>
> Jerry Bloomfield (TeamB)
> --
> http://www.teamb.com                                      JersWork@wwa.com
> Please do *NOT* send private e-mail without prior permission (my anti-spam
> filters will probably just delete it anyway <g>)